Write a SQL query to analyze warehouse performance by site, shift, and day, including throughput, accuracy, and labor cost per unit. Use the provided warehouse, shift, and operation data. Include only valid site and shift combinations with positive processed units.
site_name, shift_name, operation_date, throughput, accuracy_pct, and labor_cost_per_unit.| Column | Type | Description |
|---|---|---|
| site_idPK | INT | Unique warehouse site identifier |
| site_name | VARCHAR(100) | Warehouse site name |
| Column | Type | Description |
|---|---|---|
| shift_idPK | INT | Unique shift identifier |
| shift_name | VARCHAR(50) | Shift label |
| Column | Type | Description |
|---|---|---|
| operation_idPK | INT | Unique operation record identifier |
| site_id | INT | Warehouse site identifier |
| shift_id | INT | Shift identifier |
| operation_date | DATE | Date of the operation |
| units_processed | INT | Units processed during the operation |
| accurate_units | INT | Units processed accurately |
| labor_cost | DECIMAL(12,2) | Labor cost for the operation |