Use COUNT to aggregate rows in a fact table
quick — how many total encounters do we have on record? just one number. board wants volume stats by noon.
Each hint you reveal reduces the XP you can earn. Try the query first.
Each row in `fact_encounters` represents one patient encounter. You need a single number summarizing every row
This is an aggregate over the whole table — no grouping or filtering. Which aggregate function tallies rows?
`SELECT ___(*) AS total_encounters FROM fact_encounters` — what aggregate goes in the blank?