A neat way

  • 1

    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

Log in to reply

Looks like your connection to LeetCode Discuss was lost, please wait while we try to reconnect.