Request_At AS Day, ROUND(SUM(if(Status IN ('cancelled_by_driver', 'cancelled_by_client'), 1, 0))/COUNT(*),2) AS "Cancellation Rate"
From trips t
inner join Users u
on u.Users_id = t.Client_id
where Request_At BETWEEN '2013-10-01' AND '2013-10-03'
AND Banned = 'No'
group by 1;
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.