Tricky~24min

The Headcount Mirage

The board deck says headcount grew from 176 to 214 this quarter — strong momentum. HR ran the numbers from the HRIS export. The payroll team says their budget is off by 22%. These two facts are connected.

Tables you'll query

employeessalariesheadcount_snapshots

What you'll learn

SubqueriesJOINsNULL Handling
Investigate this case →