select Request_at as Day, round(sum(if(Status = 'completed', 0, 1)) / count(*), 2) as 'Cancellation Rate'
from Trips as t join Users as u
on t.Client_Id = u.Users_Id
where Request_at between '2013-10-01' and '2013-10-03'
and Banned = 'No'
group by Request_at
Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.