DoorDash promises delivery times to customers. The logistics team plans around the slow end, not the average: "90% of orders arrive within X minutes".
For delivered orders, show per restaurant city the median and the 90th-percentile delivery time in minutes (from ordered_at to delivered_at).
Expected output
Example of the shape (made-up values):
| city | median_minutes | p90_minutes |
|---|---|---|
| Lakeside | 33.5 | 47.2 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.