Use COUNT to aggregate rows in a fact table
Quick question — what's the total number of email sends we have on record? I need one number for the exec summary.
Each hint you reveal reduces the XP you can earn. Try the query first.
Each row in `fact_sends` represents one email sent. Use `COUNT(*)` to count all rows
Alias your result: `COUNT(*) AS total_sends` so the output column has a clear name
You should get a single row with one number. If you're getting multiple rows, you might have an accidental GROUP BY