题解 | 国庆期间近7日日均取消订单量
国庆期间近7日日均取消订单量
https://www.nowcoder.com/practice/2b330aa6cc994ec2a988704a078a0703
with dt as(
select distinct date(order_time) dt
from tb_get_car_order
where date_format(order_time,'%m%d') between '1001' and'1003'
)
select
dt,
round(count(grade)/7,2) finish_num_7d,
round(sum(case when mileage is null then 1 else 0 end)/7,2) cancel_num_7d
from
dt s1
left join
tb_get_car_order s2
on datediff(dt,date(order_time)) between 0 and 6
group by 1
order by 1 asc
阿里巴巴灵犀互娱公司福利 597人发布
投递钉钉信息等公司10个岗位
