select city, round(count(driver_id)/count(distinct driver_id),3) as avg_order_num, round(sum(fare)/count(distinct driver_id),3) as avg_income from ( select city,driver_id,fare from tb_get_car_record r right join tb_get_car_order o on r.order_id=o.order_id where date (order_time) between '2021-10-01' and '2021-10-07' and city ='北京' and driver_id in ( select driver_id from tb_get_car_order group by driver_id having count(*)>=3) ) as d 有没有大佬帮我看一下这哪里有问题?
点赞

相关推荐

犹豫的小狐狸刷了100道题:你是我在牛课上见到的最漂亮的女孩了
点赞 评论 收藏
分享
牛客网
牛客网在线编程
牛客网题解
牛客企业服务