Home
/
Questions
/
Coding
/
Find overlapping leave pairs per employee
caseSQL
Coding question · Self Join Pairs
Hard
Asked at Uber
Find overlapping leave pairs per employee
Self-join with an interval-overlap predicate.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Employees who never took leave in 2024
Next →
Count sessions per customer (30-day gap)