GROUP BY with COUNT
How many SKUs are in each velocity class? Show velocity_class and sku_count.
| Column | Type | Key |
|---|---|---|
| sku_id | INT | PK |
| sku_code | TEXT | |
| sku_name | TEXT | |
| category | TEXT | |
| velocity_class | TEXT | |
| current_zone_id | INT | FK → dim_zones |
Each hint you reveal reduces the XP you can earn. Try the query first.
Bucket SKUs by their velocity class — there's a clause that partitions rows before counting.
COUNT(*).
Alias the count.