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

  • 0

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

    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.