My solution

  • 0

    select t.Request_at AS Day, ROUND(1-avg(t.Status="completed"),2) As "Cancellation Rate"
    From (select * from Trips t1 where t1.Request_at between "2013-10-01" and "2013-10-03") t inner join (select * from Users u1 where u1.Banned="No") u on t.Client_Id = u.Users_Id
    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.