leetcode

0 SELECT a.visited_on,

1 SUM(b.day_sum) AS amount,

2 ROUND(AVG(b.day_sum), 2) AS average_amount

3 FROM

4 (SELECT visited_on, SUM(amount) AS day_sum FROM Customer GROUP BY visited_on ) a,

5 (SELECT visited_on, SUM(amount) AS day_sum FROM Customer GROUP BY visited_on ) b

6 WHERE DATEDIFF(a.visited_on, b.visited_on) BETWEEN 0 AND 6

7 GROUP BY a.visited_on

8 HAVING COUNT(b.visited_on) = 7

9 ORDER BY visited_on