DoorDash promises most orders within 45 minutes. The operations team suspects some cuisines take longer to prepare and wants data before talking to restaurants.
For delivered orders, show each cuisine's number of deliveries and the percentage that were late. A delivery is late if more than 45 minutes passed between ordered_at and delivered_at.
Expected output
late_pct as a percentage rounded to 1 decimal; any row orderExample of the shape (made-up values):
| cuisine | deliveries | late_pct |
|---|---|---|
| Ramen | 512 | 18.4 |
Hints, the later steps and the answer come with Pro.
Write your query here. Ctrl + Enter submits.