262. 行程和用户

最新推荐文章于 2024-03-18 12:45:44 发布

UQI-LIUWJ

最新推荐文章于 2024-03-18 12:45:44 发布

阅读量71

点赞数

分类专栏： leetcode 文章标签： sql

本文链接：https://blog.csdn.net/qq_40206371/article/details/119120874

版权

leetcode 专栏收录该内容

131 篇文章 0 订阅

订阅专栏

1 题目描述

显示找到非禁止的用户和司机，在指定日期内grouping一下。然后考虑是否cancel的情况。

select Request_at as Day, 
       ROUND(
            SUM(
                (IF(Status ='completed',0,1))
                )
            /COUNT(Status)
            ,2
            ) as 'Cancellation Rate'
FROM Trips
WHERE Client_Id IN(
        Select Users_Id 
        From Users 
        Where Banned = 'No' 
              AND Role='client')
       AND 
       Driver_Id IN(
        Select Users_Id 
        From Users 
        Where Banned = 'No' 
              AND Role='driver')
       AND 
       Request_at BETWEEN '2013-10-01' AND '2013-10-03'
GROUP BY Request_at