Leetcode力扣 MySQL数据库 1596 每位顾客最经常订购的商品

最新推荐文章于 2023-12-25 21:01:11 发布

ziko-1101

最新推荐文章于 2023-12-25 21:01:11 发布

阅读量110

点赞数

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

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

版权

这是一道关于LeetCode数据库查询的问题，目标是通过SQL语句从Customers, Orders和Products表中找出每位顾客最常订购的商品。问题提供了表结构和示例数据，要求返回每位顾客最常订购的商品的customer_id, product_id和product_name。" 105845176,7462898,JavaWeb Servlet 处理多个表单请求,"['JavaWeb', 'Servlet', '表单处理']

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

1596 每位顾客最经常订购的商品

SQL架构

Create table If Not Exists Customers_1569 (customer_id int, name varchar(10));
Create table If Not Exists Orders_1569 (order_id int, order_date date, customer_id int, product_id int);
Create table If Not Exists Products_1569 (product_id int, product_name varchar(20), price int);
Truncate table Customers_1569;
insert into Customers_1569 (customer_id, name) values ('1', 'Alice');
insert into Customers_1569 (customer_id, name) values ('2', 'Bob');
insert into Customers_1569 (customer_id, name) values ('3', 'Tom');
insert into Customers_1569 (customer_id, name) values ('4', 'Jerry');
insert into Customers_1569 (customer_id, name) values ('5', 'John');
Truncate table Orders_1569;
insert into Orders_1569 (order_id, order_date, customer_id, product_id) values ('1', '2020-07-31', '1', '1');
insert into Orders_1569 (order_id, order_date, customer_id, product_id) values ('2', '2020-7-30', '2', '2');
insert into Orders_1569 (order_id, order_date, customer_id, product_id) values ('3', '2020-08-29', '3', '3');
insert into Orders_1569 (order_id, order_date, customer_id, product_id) values ('4', '2020-07-29', '4', '1');
insert into Orde