Shortest answer so far

  • 0

    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.