Routine~14min

The Budget Hijack

Travel is underspent by ₹2.6 lakh. Office supplies is ~2x over budget. Finance is confused — the same team is responsible for both lines. The numbers don't add up until you look at who filed what.

Tables you'll query

departmentsbudget_allocationsemployeesexpense_claims

What you'll learn

Aggregations & GROUP BYSELECT & Filtering
Investigate this case →