Given two tables (orders and drivers), how would you identify the top 10% of drivers based on delivery speed?
Use completed deliveries with valid pickup and delivery timestamps. Define delivery speed as the driver's average delivery time in minutes, where a lower average is faster.
driver_id, driver_name, avg_delivery_minutes, and speed_decileavg_delivery_minutes ascending, then driver_id ascending for ties| Column | Type | Description |
|---|---|---|
| driver_idPK | INT | Unique identifier for the driver |
| driver_name | VARCHAR(100) | Driver's display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique identifier for the order |
| driver_id | INT | Driver assigned to the order |
| picked_up_at | TIMESTAMP | Timestamp when the driver picked up the order |
| delivered_at | TIMESTAMP | Timestamp when the order was delivered |
| status | VARCHAR(20) | Current order delivery status |