Share my solution

  • 0

    round(sum(if(t.Status = 'completed', 0, 1))/count(1),2) as Cancellation Rate,
    t.Request_at as Day
    from Trips t
    join Users u on (t.Client_id = u.Users_id and u.Banned = 'No')
    where 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.