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