Mock interview. You're interviewing for a data scientist job on a ride-hailing marketplace team. The interviewer says: "The Denver city manager says February was a disaster for completed trips. Before we act, is it real or just noise?"
A trip is completed when status = 'completed'. The data covers January to March 2026.
"Show each city's completion rate in February and in January plus March combined, and the change in points. Worst change first."
Expected output
city, other_months_rate, feb_rate, change_pts, all rounded to 1 decimal; sorted by change_pts, lowest firstExample of the shape (made-up values):
| city | other_months_rate | feb_rate | change_pts |
|---|---|---|---|
| Boston | 85.0 | 75.0 | -10.0 |
Hints, the later steps and the answer come with Pro.
Step 1 of 3
Write your query here. Ctrl + Enter submits.