Read the batching mechanic directly off fact_shopper_dispatches.batch_size with a simple distribution. Sets up the batching-economics missions in the Pro tier.
Quick one. Each dispatch fulfills one, two, or three orders, that's the batch_size. I want the distribution: how many dispatches fall in each batch size. Columns: batch_size, dispatch_count. ORDER BY batch_size.
| Column | Type | Key |
|---|---|---|
| dispatch_id | INT | PK |
| shopper_id | INT | FK → dim_shoppers |
| dispatch_ts | TEXT | |
| pickup_ts | TEXT | |
| deliver_ts | TEXT | |
| batch_size | INT | |
| pick_to_deliver_minutes | INT | |
| dispatch_status | TEXT | |
| total_distance_mi | REAL | |
| shopper_payout | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
batch_size already lives on fact_shopper_dispatches, no counting of child orders needed.
GROUP BY batch_size and COUNT(*) the dispatches.
ORDER BY batch_size so it reads 1, 2, 3.