题目
Leetcode 1321. 餐馆营业额变化增长
代码(7.25 首刷看解析)
- 每天的amount求和
- 将求和的表作为子表查俩次
- 用datediff()函数求日期差
- c1.visited_on分组,count()次数要等于7(必须得是7天的才行,少于7天的需要排除掉)
select c1.visited_on visited_on, sum(c2.amount) amount, round(avg(c2.amount), 2) average_amount from
(select visited_on, sum(amount) amount from Customer group by visited_on) c1,
(select visited_on, sum(amount) amount from Customer group by visited_on) c2
where datediff(c1.visited_on, c2.visited_on) >= 0 and datediff(c1.visited_on, c2.visited_on) < 7
group by c1.visited_on having count(1) = 7;