Leetcode力扣 MySQL数据库 1174 即时食物配送II

最新推荐文章于 2024-03-30 23:45:20 发布

ziko-1101

最新推荐文章于 2024-03-30 23:45:20 发布

阅读量156

点赞数

分类专栏： Leetcode MySQL数据库（VIP）题目及解答文章标签：数据库 mysql leetcode

本文链接：https://blog.csdn.net/m0_46458212/article/details/127445237

版权

本文介绍了如何使用SQL查询即时订单在所有用户首次订单中的比例，通过分析LeetCode上的1174题，讨论了配送表的结构，并给出了解决方案。

摘要由CSDN通过智能技术生成

1174 即时食物配送II

SQL架构

Create table If Not Exists Delivery_1174 (delivery_id int, customer_id int, order_date date, customer_pref_delivery_date date);
Truncate table Delivery_1174;
insert into Delivery_1174 (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('1', '1', '2019-08-01', '2019-08-02');
insert into Delivery_1174 (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('2', '2', '2019-08-02', '2019-08-02');
insert into Delivery_1174 (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('3', '1', '2019-08-11', '2019-08-12');
insert into Delivery_1174 (delivery_id, customer_id, order_date, customer_pref_delivery_date) values ('4', '3', '2019-08-24', '2019-08-24');
insert into Delivery_1174 (delivery_id, customer_id, order_date, custom