COUNT(*) on a dimension
Welcome to the DC. First task — how many distinct pick zones are configured in `dim_zones`? Single number, alias `zone_count`.
| Column | Type | Key |
|---|---|---|
| zone_id | INT | PK |
| zone_name | TEXT | |
| velocity_target | TEXT | |
| pick_travel_multiplier | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
There's a single-table aggregate that returns one number — count every row in the zone dim.
Single column.
Alias as zone_count.