Practice Interview Questions
| Question | Status |
|---|---|
Evaluate the performance of delivery drivers with precision. Your task: Find the average order value for drivers who've successfully completed deliveries within 45 minutes.
Output the driver ID along with their respective average order values.
delivery_details table:
| Column Name | Data type |
|---|---|
| customer_placed_order_datetime | timestamp |
| placed_order_with_restaurant_datetime | timestamp |
| driver_at_restaurant_datetime | timestamp |
| delivered_to_consumer_datetime | timestamp |
| driver_id | int |
| restaurant_id | int |
| consumer_id | int |
| order_total | float |
| driver_id | avg_total |
|---|---|
| 225 | 103.121.. |
| 34 | 48.22.. |
Evaluate the performance of delivery drivers with precision. Your task: Find the average order value for drivers who've successfully completed deliveries within 45 minutes.
Output the driver ID along with their respective average order values.
delivery_details table:
| Column Name | Data type |
|---|---|
| customer_placed_order_datetime | timestamp |
| placed_order_with_restaurant_datetime | timestamp |
| driver_at_restaurant_datetime | timestamp |
| delivered_to_consumer_datetime | timestamp |
| driver_id | int |
| restaurant_id | int |
| consumer_id | int |
| order_total | float |
| driver_id | avg_total |
|---|---|
| 225 | 103.121.. |
| 34 | 48.22.. |