题解 | #有取消订单记录的司机平均评分#

with t1 as(select  DISTINCT driver_id from tb_get_car_order
WHERE DATE_FORMAT(order_time, "%Y-%m")='2021-10' AND ISNULL(fare))

select ifnull(driver_id,'总体'),round(avg(grade),1)
from t1 join tb_get_car_order
using(driver_id)
where grade is not null 
group by driver_id
with ROLLUP