注意点:找到21年10月有过取消订单记录的司机,只要在该时间段有取消记录则都计入
with rollup: 写在分组函数之后,会对分组后的数据进行汇总。用的比较少,这里记录一下
select ifnull(co.driver_id, '总体') as driver_id, round(avg(co.grade), 1) as avg_grade from tb_get_car_order co where co.driver_id in ( select co.driver_id from tb_get_car_order co where co.fare is null and co.finish_time between '2021-10-01' and '2021-11-01' ) group by co.driver_id with rollup