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

select
    '北京' as 'city',
    round(avg(c.d),3) as avg_order_num,
    round(avg(c.e),3) as avg_income
from
    (
        select
            b.driver_id,
            count(a.order_id) as d,
            sum(b.fare)  as e
        from 
            tb_get_car_record as a
        inner join tb_get_car_order as b on a.order_id = b.order_id
        where
            a.city = '北京'
            and date_format(order_time, '%Y%m%d') between '20211001' and '20211007'
        group by
            b.driver_id
        having
            count(a.order_id) >= 3
    ) as c
	1.先按照司机id分组求出每个司机的接单数和总金额，在筛选时间地点以及订单量
	2.在求出平均每个司机的接单量和平均收入