题解 | #2021年国庆北京接单3次及以上的司机信息#

with
    dataList as (
        select
            driver_id,
            city,
            count(order_time) allordernum,
            sum(if(fare is null , 0, fare)) allfare
        from
            tb_get_car_order
            join tb_get_car_record using (order_id)
        where 
            date(order_time) between '2021-10-01' and '2021-10-07'
        group by
            driver_id,
            city
        having
            count(order_time) >= 3
    )
select
    city,
    round(avg(allordernum), 3) avg_order_num,
    round(avg(allfare), 3) avg_income
from
    dataList
group by
    city
having 
    city = '北京'

本题难度不大，主要是用户打车订单表会存在一个用户取消order_id的情况，与打车订单表应该做一个order_id的链接即可，根据时间在国庆七天内就可以筛选出来，至于city='北京'在having或者where内都可以的