【LeetCode】262.Trips and Users

题目:https://leetcode.com/problems/trips-and-users/

解决方案：

需要得到有效用户对象+完成数据量+未完成数据量+时间

SELECT l1.Day Day, ROUND(SUM(l1.cn)/(SUM(l1.cp)+SUM(l1.cn)),2) AS "Cancellation Rate"

FROM(

SELECT T.Request_at Day, if(T.status="completed",1,0) cp, if(T.status!="completed",1,0) cn

FROM Trips T , Users C

WHERE(T.Client_Id = C.Users_ID

AND C.Banned="NO"

AND T.Request_at >= "2013-10-01"

AND T.Request_at <= "2013-10-03")

) l1

GROUP BY l1.Day