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

select city, round(avg(num),3) as avg_order_num, round(avg(income),3) as avg_income from ( select '北京' as city, driver_id, count(order_time) as num, sum(fare) as income from tb_get_car_order o left join tb_get_car_record r using(order_id) where r.city = '北京' and date(order_time) BETWEEN '2021-10-01' and '2021-10-07' group by driver_id having num >= 3 )a group by city