Mock interview. You're interviewing for a data analyst job on a ride-hailing operations team. The interviewer shares the trips table: one row per ride request, with a status of completed, cancelled or no_driver. "Two quick ones about March."
"For March 2026: ride requests, completion rate, gross bookings (total fares) and the average fare of completed trips."
Expected output
completion_rate as a percentage rounded to 1 decimal; avg_fare rounded to 2 decimalsExample of the shape (made-up values):
| requests | completion_rate | gross_bookings | avg_fare |
|---|---|---|---|
| 600 | 85.0 | 11000.00 | 21.57 |
Hints, the later steps and the answer come with Pro.
Step 1 of 2
Write your query here. Ctrl + Enter submits.