leetcode

0 SELECT request_at AS Day,

1 ROUND(AVG(status LIKE 'cancelled%'), 2) AS "Cancellation Rate"

2 FROM Trips

3 WHERE client_id IN (

4 SELECT users_id

5 FROM Users

6 WHERE banned = 'No'

7 )

8 AND driver_id IN (

9 SELECT users_id

10 FROM Users

11 WHERE banned = 'No'

12 )

13 AND request_at BETWEEN "2013-10-01" AND "2013-10-03"

14 GROUP BY request_at

15