一、题目
二、代码
select a.visited_on,sum(b.amount) as amount , round(avg(b.amount ),2) as average_amount from
(
select visited_on,sum(amount) as amount from Customer
group by visited_on
) as a
join
(
select visited_on,sum(amount) as amount from Customer
group by visited_on
) as b
on datediff(a.visited_on,b.visited_on ) between 0 and 6
where a.visited_on in
(
select distinct visited_on from Customer
where datediff(visited_on, (select min(visited_on) from Customer ))>=6
)
group by a.visited_on
order by a.visited_on asc
三、运行结果