AVG of computed variance
Average cycle-count variance % by zone. Show zone_id, avg_variance_pct.
| Column | Type | Key |
|---|---|---|
| count_id | INT | PK |
| zone_id | INT | FK → dim_zones |
| sku_id | INT | FK → dim_skus |
| worker_id | INT | FK → dim_workers |
| count_date | TEXT | |
| system_qty | INT | |
| counted_qty | INT | |
| variance_pct | REAL |
Each hint you reveal reduces the XP you can earn. Try the query first.
Average variance per zone — group the cycle counts, then aggregate the variance column.
AVG(variance_pct).
Two columns.