Share my solutuion


  • 0
    S
    select t.Request_at as Day, round(sum(t.Status like "cancelled%")/count(*),2) as "Cancellation Rate"
    from
    Trips t join Users u
    on t.Client_Id = u.Users_Id
    where u.Banned = "No"
    and t.Request_at between "2013-10-01" and "2013-10-03"
    group by t.Request_at

Log in to reply
 

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