Trips and Users Cancellation Rate

The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are foreign keys to the Users_Id in the Users table. Status is an ENUM of ('completed', 'cancelled_by_driver', 'cancelled_by_client'). The Users table holds all users; each user has a unique Users_Id, Role is an ENUM of ('client', 'driver', 'partner'), and Banned is an ENUM of ('Yes', 'No').

Write a SQL query to find the cancellation rate of requests with unbanned users (both the client and the driver must not be banned) for each day between "2013-10-01" and "2013-10-03". A request is cancelled if its status is either 'cancelled_by_driver' or 'cancelled_by_client'. The cancellation rate is the number of cancelled requests divided by the total number of requests (all involving unbanned users) on that day. Round the cancellation rate to two decimal places. Return one row per day that has at least one trip in the period, showing the day and its cancellation rate.