Mock interview. You're interviewing for a senior analyst job on a food delivery app's restaurant partnerships team. The interviewer says: "Our account managers can only call so many restaurants. Help us decide who to focus on."
Unless a step says otherwise, use orders placed from 1 January to 31 May 2026. Gross order value (GOV) is the sum of order_total for delivered orders. Include restaurants with no orders as 0.
"For each price_level (1 = cheapest, 4 = priciest): restaurants, orders per restaurant, GOV per restaurant, and the cancellation rate."
Expected output
price_level, restaurants, orders_per_restaurant (1 decimal), gov_per_restaurant (2 decimals), cancel_rate (a percentage, 1 decimal); sorted by price_levelExample of the shape (made-up values):
| price_level | restaurants | orders_per_restaurant | gov_per_restaurant | cancel_rate |
|---|---|---|---|---|
| 1 | 25 | 30.0 | 900.00 | 3.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 4
Write your query here. Ctrl + Enter submits.