Shortest answer so far


  • 0
    A

    select
    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;


Log in to reply
 

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