Cancellation Rate for Unbanned Users
Cancellation Rate for Unbanned Users
HardSQL0% accepted
Given Trips and Users tables, find the cancellation rate of requests made by unbanned users between two dates. Rate = cancelled trips / total trips, rounded to 2 decimal places.
Approach
Calculate trip cancellation rate for unbanned users in a date range.
Input
10 trips, 2 cancelled, all users unbanned
Output
0.20 cancellation rate
More SQL problems
Browse all coding problems →Scenarios & Expected Answers
Sign in to continue
Create a free account to view answers and mark progress.
- Free forever — no credit card
- Theory Q&A with detailed answers
- Points, streaks & leaderboards