Mock interview. You're interviewing for an operations analyst job on a grocery delivery team. The interviewer says: "Customer complaints about late orders are up. Shoppers are also asking why their tips fell. Can you connect the dots?"
Use delivered orders only. An order is on time when delivered_at <= promised_by.
"Show the on-time rate for each month of 2026, and the change in points from the month before."
Expected output
on_time_rate as a percentage rounded to 1 decimal; change_pts empty for January; sorted by monthExample of the shape (made-up values):
| month | orders | on_time_rate | change_pts |
|---|---|---|---|
| 2026-01-01 | 200 | 80.0 | |
| 2026-02-01 | 220 | 78.0 | -2.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.