Routine~11min

The Backdated Leave

Company policy requires leave to be applied at least 1 day before it starts. 22 leave requests were submitted after the leave had already begun. One employee accounts for 18 of them. A handful of same-day sick leaves are allowed — those are fine.

Tables you'll query

employeesleave_requests

What you'll learn

Date & Time FunctionsSELECT & Filtering
Investigate this case →