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
Investigate this case →