CASE WHEN for flagging conditions
Before the exec meeting — which cost centers are OVER budget for March 2025? Just the overspenders. Columns: `cost_center_name`, `budget`, `actual`, `overage` (actual minus budget). Sort by overage descending.
Each hint you reveal reduces the XP you can earn. Try the query first.
Reuse the mission-11 shape, but HAVING or WHERE the actual > budget.
Or use a CASE to flag and then filter — either works.
Sort `ORDER BY overage DESC` so the worst appears first.