计算每天的完成订单数和取消订单数目round(sum(if(fare is not null, 1, 0))/7, 2) finish_num_7d, round(sum(if(fare is null, 1, 0))/7, 2) cancel_num_7d 列出国庆前三天时间with tb_day as (select distinct date(order_time) sdt from tb_get_car_order where date(order_time) between '2021-10-01' and '2021-10-3' ) 把国庆前三天每天...