GROUP BY month (ignoring year) to reveal seasonality
I'm modeling 2026 — need the 'shape' of our revenue year. Group revenue across 2023-2025 by calendar month (1-12, ignoring year). Use LOWER() for the revenue filter. Columns: `month`, `total_revenue`.
Each hint you reveal reduces the XP you can earn. Try the query first.
Filter `LOWER(account_type) = 'revenue'`, posted = 1.
GROUP BY `EXTRACT(MONTH FROM txn_date::date)` — across all 3 years combined.
Sort by month ascending. You'll get 12 rows (one per calendar month).