Date filtering on a TEXT date column
March close — give me total OpEx spend for March 2025 across all cost centers. Join `dim_accounts`, filter to OpEx accounts, posted entries only. Single number, column `total_march_opex`.
Each hint you reveal reduces the XP you can earn. Try the query first.
Filter `dim_accounts` to `account_type = 'OpEx'` (casing matters — lowercase works for OpEx specifically).
Filter the year and month: `EXTRACT(YEAR FROM txn_date::date) = 2025 AND EXTRACT(MONTH FROM txn_date::date) = 3`.
SUM(amount) with posted = 1 → single row, single column named `total_march_opex`.