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