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

select
    "北京" city,
    round(AVG(driver_order),3) avg_order_num,
    round(AVG(money),3) avg_income
from(
    select  city,count(order_id) driver_order,sum(fare) money
    from
    tb_get_car_record join tb_get_car_order
    using(order_id )
    where  
        city = "北京" and DATE_FORMAT(order_time,"%Y%m%d") BETWEEN '20211001' AND '20211007'
    group by driver_id
    having driver_order > 2
)t