select '北京' as city,round(avg(order_num),3) as avg_order_num,round(avg(fare_num),3) as avg_income from ( select driver_id,count(a.order_id) order_num,sum(fare) as fare_num from tb_get_car_order a left join tb_get_car_record b on a.uid=b.uid where city='北京' and date(event_time) between '2021-10-01' and '2021-10-07' and order_time is not null group by driver_id having count(a.order_id)>=3 ) t; 请问这样为什么不对呢
点赞

相关推荐

牛客网
牛客企业服务