My solution without join


  • 0
    X

    Write your MySQL query statement below

    select Request_at as Day, round(sum(if(Status !='completed',1,0))/count(Status),2) as 'Cancellation Rate'
    from Trips
    where (Request_at between '2013-10-01' and '2013-10-03')
    and Client_Id in (select Users_Id from Users where Banned='No' and Role='client')
    group by Request_at


Log in to reply
 

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