Write a SQL query to analyze Chewy fulfillment center performance by day, joining orders and labor tables to calculate throughput, on-time rate, and average labor hours.
Use the provided orders and labor tables. Throughput is fulfilled orders per labor hour, and on-time rate is the percentage of orders delivered by the promised date.
fulfillment_center_id, performance_date, orders_fulfilled, throughput, on_time_rate, and average_labor_hours.performance_date, then fulfillment_center_id.| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| fulfillment_center_id | VARCHAR(10) | Chewy fulfillment center identifier |
| order_date | DATE | Date the order was fulfilled |
| promised_delivery_date | DATE | Date promised to the customer |
| delivered_at | DATE | Actual delivery date |
| Column | Type | Description |
|---|---|---|
| labor_record_idPK | INT | Unique labor record identifier |
| fulfillment_center_id | VARCHAR(10) | Chewy fulfillment center identifier |
| labor_date | DATE | Date labor was recorded |
| labor_hours | NUMERIC(8,2) | Hours recorded for the labor entry |