My AC solution. please help me check the correctness

  • 0

    SELECT Request_at AS Day, ROUND(COUNT(CASE WHEN Status LIKE "cancelled_by_%" THEN 1 ELSE NULL END)/COUNT(*),2) AS 'Cancellation Rate'
    FROM Trips
    WHERE Client_Id NOT IN (SELECT Users_Id FROM Users WHERE Banned ="Yes" AND Role="client")
    GROUP BY Request_at HAVING Request_at BETWEEN '2013-10-01' AND '2013-10-03'

Log in to reply

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