select ifnull(driver_id,'总体'),
round(avg(grade),1) as avg_grade

from tb_get_car_order
where driver_id in (select driver_id from tb_get_car_order where grade is null)

group by driver_id

with rollup

二刷