Tricky~22min
The Carry-Forward Bug
47 employees are complaining their carry-forward leave balance is wrong — they show 0 carry-over when they should have had 4-10 days. HR says the system is fine. The system is not fine.
Tables you'll query
employeesdepartment_transfersleave_balances
What you'll learn
SubqueriesJOINsDate & Time Functions