先晒出国庆三天的日期（这个方法好蠢哦 计算每天的接单和取消单 国庆日期和7天日期连接，计算日均值

with 
t1 as
(
select distinct date_format(order_time,'%Y%m%d') as dt_3
from tb_get_car_order 
where date_format(order_time,'%Y%m%d') in('20211001','20211002','20211003'))
,
t2 as
(select date_format(order_time,'%Y%m%d') as dt_7,
 ifnull(count(start_time),0) as finish_num,ifnull(count(1)-count(start_time),0) as cancel_num
from tb_get_car_order
 group by 1
)

select date_format(dt_3,'%Y-%m-%d') as dt,round(avg(finish_num),2) as finish_number_7d,
round(avg(cancel_num),2) as cancel_number_7d
from t1
left join t2
on datediff(dt_3, dt_7) between 0 and 6
group by 1
order by 1