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; 请问这样为什么不对呢
点赞

相关推荐

程序员花海:实习和校招简历正确格式应该是教育背景+实习+项目经历+个人评价 其中项目经历注意要体现业务 实习经历里面的业务更是要自圆其说 简历模板尽可能保持干净整洁 不要太花哨的
985本硕1个中小厂of...
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务