# 找到这些司机完成订单 dirver_id,order_id,grade
with a as(
    select o.driver_id,o.order_id,o.grade
    from tb_get_car_order as o 
    where o.driver_id in (
        select distinct driver_id 
        from tb_get_car_order 
        where start_time is null 
            and date(order_time) between '2021-10-01' 
            and '2021-10-07')
        and o.start_time is not null
)
select a.driver_id,round(avg(a.grade),1) as avg_grade
from a
group by a.driver_id
union
select '总体' as driver_id,round((select avg(grade) from a),1) as avg_grade