一开始这里count(1) 写成了count(start_time) 后来发现我想多了，只要司机接单就可了

(select driver_id,count(1) as num,sum(fare) as income
from tb_get_car_order 
left join tb_get_car_record using(order_id)
where date_format(order_time,'%Y%m%d') >= '20211001' and date_format(order_time,'%Y%m%d') <= '20211007'
and city = '北京'
group by 1
having num >= 3
)

select '北京' as city, round(avg(num),3) as avg_order_num,round(avg(income),3) as avg_order_income
from t1