COUNT(*) on a dimension
How many distinct locations in `dim_locations`? Single number, alias `location_count`.
| Column | Type | Key |
|---|---|---|
| location_id | INT | PK |
| location_name | TEXT | |
| region | TEXT | |
| dc_type | TEXT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Aggregate over a single dim to return one number — the location dim is small.
Single column.
Alias.