[LeetCode]--262. Trips and Users

最新推荐文章于 2023-08-04 11:26:58 发布

beijingbuaaer

最新推荐文章于 2023-08-04 11:26:58 发布

阅读量265

点赞数

分类专栏： SQL leecode整理

leecode整理同时被 2 个专栏收录

48 篇文章 0 订阅

订阅专栏

SQL

2 篇文章 0 订阅

订阅专栏

Let’s see the problem!
这里写图片描述

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

Show the code!

# Write your MySQL query statement below
SELECT Request_at as Day,
       ROUND(COUNT(IF(Status != 'completed', TRUE, NULL)) / COUNT(*), 2) AS 'Cancellation Rate'
FROM Trips
WHERE (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;