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