统计国庆头三天里,每天的近7日日均订单完成量和日均订单取消量代码如下:select * from( select dt, round(sum(finish_num)over(order by dt rows 6 preceding)/7,2) as finish_num_7d, round(sum(cancel_num)over(order by dt rows 6 preceding)/7,2) as cancel_num_7d from ( select date(order_time)dt, sum(case when st...