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

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

https://www.nowcoder.com/practice/2b330aa6cc994ec2a988704a078a0703

select 
    *
from(
    select 
        dt,
        round(avg(wc_cnt) over (order by dt asc rows between 6 preceding and current row),2) as finish_num_7d,
        round(avg(wwc_cnt) over (order by dt asc rows between 6 preceding and current row),2) as cancel_num_7d
    from(
        select 
            date(order_time) as dt,
            sum(if(mileage is not null,1,0)) as wc_cnt,
            sum(if(mileage is null,1,0)) as wwc_cnt
        from 
            tb_get_car_order
        group by 1
        order by dt) as a
    order by dt) as b
where dt between '2021-10-01' and '2021-10-03'

全部评论

相关推荐

06-10 21:15
门头沟学院 Java
宁阿:好多这种没🧠的公司,他们估计都不知道毕业的人不能给安排实习岗
实习吐槽大会
点赞 评论 收藏
分享
评论
点赞
收藏
分享

创作者周榜

更多
牛客网
牛客网在线编程
牛客网题解
牛客企业服务