my accepted solution (283 ms)

  • 0
    SELECT Request_At AS Day, ROUND(COUNT(CASE WHEN Status LIKE 'cancelled%' THEN 1 END)/COUNT(Trips.Id),2) AS "Cancellation Rate"
      FROM Trips JOIN Users ON Trips.Client_Id = Users.Users_Id
      WHERE Banned = 'No'
      AND Request_At BETWEEN '2013-10-01' AND '2013-10-03'
      GROUP BY Request_At
      ORDER BY Request_At

Log in to reply

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