GROUP BY with computed rate
Compute units per labor hour by zone — sum qty_picked, sum minutes elapsed, divide. Show zone_id, uplh.
| 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.
UPLH = units picked per labor hour. You'll need two aggregates and a unit conversion across zones.
SUM duration in minutes per zone, convert to hours.
UPLH = units / hours.