HELP!! What is wrong with my answer that I keep getting runtime error?!?!?!


  • 0
    C

    SELECT
    C.Day, ROUND(
    (SELECT COUNT(C.Status) FROM C WHERE C.Status LIKE "cancelled_%")/(SELECT COUNT(C.Status) FROM C)
    ,2)
    AS "Cancellation Rate"

    FROM(
    SELECT t.Client_Id, u.Users_Id, t.Request_at AS Day, t.Status AS Status
    FROM Trips t LEFT JOIN Users u
    ON t.Client_Id=u.Users_Id
    WHERE Banned="No" AND t.Request_at>="2013-10-01 "AND t.Request_at<="2013-10-03") AS C

    GROUP BY C.Day


Log in to reply
 

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