Home
/
Questions
/
Coding
/
Employees who never took leave in 2024
caseSQL
Coding question · Left Join Null
Hard
Asked at LinkedIn
Employees who never took leave in 2024
LEFT JOIN + IS NULL combined with a date predicate on the joined side.
Unlock with Pro
→
Back to all coding questions
The Brief
← Previous
Second-best seller in each category
Next →
Find overlapping leave pairs per employee