题解 | #有取消订单记录的司机平均评分#
有取消订单记录的司机平均评分
http://www.nowcoder.com/practice/f022c9ec81044d4bb7e0711ab794531a
SELECT COALESCE(driver_id, '总体') AS 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 DATE_FORMAT(order_time, '%Y%m') = '202110'
AND ISNULL(fare)
) AND NOT ISNULL(grade)
GROUP BY driver_id
WITH ROLLUP