Tricky~22min

The Double Allocation

Q3 bonus payouts just landed. Per-project, the numbers look right. Total company bonus spend is ₹6L over the approved budget. Finance says the approval amounts were correct. HR says the payouts were correct. Both can't be telling the full story.

Tables you'll query

employeesproject_teamsbonuses

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →