GROUP BY with COUNT and LIMIT
Top 10 SKUs by pick task count. Show sku_id and pick_count.
| Column | Type | Key |
|---|---|---|
| task_id | INT | PK |
| order_id | INT | |
| sku_id | INT | FK → dim_skus |
| zone_id | INT | FK → dim_zones |
| worker_id | INT | FK → dim_workers |
| wave_id | INT | |
| shift | TEXT | |
| pick_start_ts | TEXT | |
| pick_end_ts | TEXT | |
| qty_requested | INT | |
| qty_picked | INT | |
| pick_error_flag | INT |
Each hint you reveal reduces the XP you can earn. Try the query first.
Rank SKUs by how often they appear in the pick fact — group, count, sort, cap.
COUNT(*) of pick tasks.
ORDER BY DESC, LIMIT 10.