Leetcode力扣 MySQL数据库 1321 餐馆营业额变化增长

最新推荐文章于 2024-08-01 00:15:55 发布

ziko-1101

最新推荐文章于 2024-08-01 00:15:55 发布

阅读量116

点赞数

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

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

版权

通过SQL查询，计算以7天为周期的餐馆每日顾客消费平均值，以评估营业额变化。示例展示了如何根据Customer表中的数据，按日期顺序计算每个7天周期的平均消费，并保留两位小数。

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

1321 餐馆营业额变化增长

SQL架构

Create table If Not Exists Customer_1321 (customer_id int, name varchar(20), visited_on date, amount int);
Truncate table Customer_1321;
insert into Customer_1321 (customer_id, name, visited_on, amount) values ('1', 'Jhon', '2019-01-01', '100');
insert into Customer_1321 (customer_id, name, visited_on, amount) values ('2', 'Daniel', '2019-01-02', '110');
insert into Customer_1321 (customer_id, name, visited_on, amount) values ('3', 'Jade', '2019-01-03', '120');
insert into Customer_1321 (customer_id, name, visited_on, amount) values ('4', 'Khaled', '2019-01-04', '130');
insert into Customer_1321 (customer_id, name, visited_on, amount) values ('5', 'Winston', '2019-01-05', '110');
insert into Customer_1321 (customer_id, name, visited_on, amount) value