[LeetCode]--262. Trips and Users

Let’s see the problem!

Let’s see some concise answer, this is the Portal

Show the code!

# Write your MySQL query statement belowSELECT Request_at as Day,       ROUND(COUNT(IF(Status != 'completed', TRUE, NULL)) / COUNT(*), 2) AS 'Cancellation Rate'FROM TripsWHERE (Request_at BETWEEN '2013-10-01' AND '2013-10-03')      AND Client_id NOT IN (SELECT Users_Id FROM Users WHERE Banned = 'Yes')GROUP BY Request_at;