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