SQL Server 2012

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

/*drop table Trips;
drop table Users;
truncate table Users;
truncate table Trips;
*/
CREATE TABLE Trips
    ([Id] int, [Client_Id] int, [Driver_Id] int, [City_Id] int, [Status] varchar(19), [Request_at] varchar(50))
;
    
INSERT INTO Trips
    ([Id], [Client_Id], [Driver_Id], [City_Id], [Status], [Request_at])
VALUES
    (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')
;

CREATE TABLE Users 
    ([Users_Id] int, [Banned] varchar(3), [Role] varchar(6))
;
    
INSERT INTO Users 
    ([Users_Id], [Banned], [Role])
VALUES
    (1, 'No', 'client'),
    (2, 'Yes', 'client'),
    (3, 'No', 'client'),
    (4, 'No', 'client'),
    (10, 'No', 'driver'),
    (11, 'No', 'driver'),
    (12, 'No', 'driver'),
    (13, 'No', 'driver')
;

18 rows affected

Day	Cancellation_Rate
2013-10-01	0.330000
2013-10-02	0.000000
2013-10-03	0.500000