Tricky~21min

The OT Shortfall

Three permanent employees filed a formal complaint: they were paid 1.5x for overtime instead of the 2x rate in their contracts. Payroll says the system applied the correct multiplier. Pull the overtime records and check.

Tables you'll query

employeesot_policyovertime_records

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →