LeetCode刷题---即时食物配送 II

最新推荐文章于 2024-05-31 13:35:03 发布

肥大毛

最新推荐文章于 2024-05-31 13:35:03 发布

阅读量364

点赞数 11

分类专栏：大数据 MySQL LeetCode刷题文章标签： leetcode 职场和发展 sql

本文链接：https://blog.csdn.net/weixin_47109902/article/details/136665194

版权

LeetCode刷题同时被 3 个专栏收录

67 篇文章 1 订阅

订阅专栏

大数据

34 篇文章 0 订阅

订阅专栏

MySQL

13 篇文章 0 订阅

订阅专栏

在这里插入图片描述

LeetCode题解

解题思路:

1.首先先求出每个用户首次订单表，将其命名为表t

 （select customer_id,min(order_date) as order_date
    from Delivery
    group by customer_id）as t

2.与原表连接，求出在用户首次订单表中即时订单的数量的总和

select sum(order_date = customer_pref_delivery_date) from
t,Delivery
where t.customer_id = Delivery.customer_id and t.order_date = Delivery.order_date

3.求出每个用户首次订单的数量

select distinct(customer_id) from Delivery

4.计算得到最终结果

完整SQL代码：

select round(sum(if(t.order_date = customer_pref_delivery_date,1,0))*100/(select count(*) from
(select distinct customer_id from Delivery) t1),2) as immediate_percentage
from (
    select customer_id,min(order_date) as order_date
    from Delivery
    group by customer_id
) t,Delivery
where t.customer_id = Delivery.customer_id and t.order_date = Delivery.order_date