Cancellation rate by city
Operations watch cancellations. For each city, compute the share of cancelled trips as a percentage rounded to two decimals. Return city and cancel_pct, ordered by city.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.
| city | cancel_pct |
|---|---|
| Kazan | 33.33 |
| Moscow | 25 |
| Sochi | 50 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in