Mock interview. You're interviewing for an operations analyst job on a food delivery team. The interviewer says: "Los Angeles customers complain about slow deliveries. Is LA really slower, and if so, is it the restaurants or the drive?"
Use delivered orders from all the data (November 2025 to May 2026). Each delivery has ordered_at, picked_up_at and delivered_at.
"Show each city's delivered orders, average delivery time in minutes, and how many minutes above or below the all-cities average that is."
Expected output
city, orders, avg_minutes, vs_overall (both rounded to 1 decimal); sorted by avg_minutes, highest firstExample of the shape (made-up values):
| city | orders | avg_minutes | vs_overall |
|---|---|---|---|
| Boston | 500 | 45.0 | 6.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.