leetcodeSQL262 题行程和用户Mysql

2333!!!!!

于 2022-10-13 14:26:44 发布

阅读量167

点赞数

分类专栏： mysql 文章标签：数据库 sql mysql

本文链接：https://blog.csdn.net/weixin_46564011/article/details/127300800

版权

mysql 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

笨比解法我是笨比

select distinct sums.request_at as `Day`, ifnull(convert(cancle.counts/sums.counts,decimal(15,2)),0.00) as `Cancellation Rate` from
(select count(*) as counts,ppt.request_at from
(select tc.*,uc.banned as driverBan from 
(select t.*,u.banned as clientBan from Trips t left join Users u
on
t.client_id=u.users_id) as tc left join Users uc
on
tc.driver_id=uc.users_id) as ppt
where ppt.driverBan='No' and ppt.clientBan='No' and ppt.request_at between '2013-10-01' and
'2013-10-03' and ppt.status!='completed' group by ppt.request_at) as cancle 
right join
(select count(*) as counts,ppt.request_at from
(select tc.*,uc.banned as driverBan from 
(select t.*,u.banned as clientBan from Trips t left join Users u
on
t.client_id=u.users_id) as tc left join Users uc
on
tc.driver_id=uc.users_id) as ppt
where ppt.driverBan='No' and ppt.clientBan='No' and ppt.request_at between '2013-10-01' and
'2013-10-03'  group by ppt.request_at) as sums
on sums.request_at=cancle.request_at