Tricky~24min

The Budget Shuffle

Q4 finance review: all 5 departments are under budget. CFO is happy. But total capex spend is ₹21.1L over plan and opex is ₹93.2L under. The department view and the category view tell completely different stories.

Tables you'll query

departmentsbudget_allocationsexpenses

What you'll learn

SubqueriesJOINsAggregations & GROUP BY
Investigate this case →