题解 | 国庆期间近7日日均取消订单量

with
t1 as(
    select
        '2021-10-01' as dt,
        round(count(fare)/7,2) as finish_num_7d,
        round((count(*)-count(fare))/7,2) as cancel_num_7d
    from
        tb_get_car_order
    where
        date_format(order_time,'%Y-%m-%d') between '2021-09-25' and '2021-10-01'),
t2 as(
    select
        '2021-10-02' as dt,
        round(count(fare)/7,2) as finish_num_7d,
        round((count(*)-count(fare))/7,2) as cancel_num_7d
    from
        tb_get_car_order
    where
        date_format(order_time,'%Y-%m-%d') between '2021-09-26' and '2021-10-02'),
t3 as(
    select
        '2021-10-03' as dt,
        round(count(fare)/7,2) as finish_num_7d,
        round((count(*)-count(fare))/7,2) as cancel_num_7d
    from
        tb_get_car_order
    where
        date_format(order_time,'%Y-%m-%d') between '2021-09-27' and '2021-10-03')

select * from t1
union 
select * from t2
union
select * from t3