[Leetcode] Trips and users travel and user

The Trips table holds all taxi trips. Each trips has a unique Id, while client_id and driver_id is both foreign keys to the users_id at the Users table. The Status is an ENUM of type of (' Completed ', ' cancelled_by_driver ', ' cancelled_by_client ').

+----+-----------+-----------+---------+--------------------+----------+| Id | client_id | driver_id |        city_id | Status | request_at|+----+-----------+-----------+---------+--------------------+----------+|     1 |    1 |    10 |     1 | Completed |2013-10-01| |     2 |    2 |    11 | 1 | cancelled_by_driver|2013-10-01| |     3 |    3 |    12 |     6 | Completed |2013-10-01| |     4 |    4 |    13 | 6 | cancelled_by_client|2013-10-01| |     5 |    1 |    10 |     1 | Completed |2013-10-02| |     6 |    2 |    11 |     6 | Completed |2013-10-02| |     7 |    3 |    12 |     6 | Completed |2013-10-02| |     8 |    2 |    12 |     12 | Completed |2013-10-03| |     9 |    3 |    10 |     12 | Completed |2013-10-03| |     10 |    4 |    13 | 12 | cancelled_by_driver|2013-10-03|+----+-----------+-----------+---------+--------------------+----------+ 

The Users table holds all users. Each user has a unique users_id, and Role is an ENUM type of (' Client ', ' driver ', ' partner ').

+----------+--------+--------+| users_id | Banned |  Role  |+----------+--------+--------+|    1     |   No   | client | |    2     |   Yes  | client | |    3     |   No   | client | |    4     |   No   | client | |    Ten    |   No   | driver | |    One    |   No   | driver | |    |   No   | driver | |    |   No   | driver |+----------+--------+--------+

Write a SQL query to find the cancellation rate of requests made by unbanned clients between Oct 1, and Oct 3, 2013. For the above tables, your SQL query should return the following rows with the cancellation rate being rounded to decimal places.

+------------+-------------------+|     Day    | Cancellation rate |+------------+-------------------+| 2013-10-01 |       0.33        | | 2013-10-02 |       0.00        | | 2013-10-03 |       0.50        |+------------+-------------------+

S

[Leetcode] Trips and users travel and user