题解 | 物流公司想要分析快递小哥的收入情况

select a.courier_id, courier_name, sum_delivery_fee+base_salary as total_income
from (
    select courier_id, sum(delivery_fee) as sum_delivery_fee
    from deliveries_info
    where year(delivery_date)=2024 and month(delivery_date)=7
    group by courier_id
) a join couriers_info b on a.courier_id=b.courier_id
group by a.courier_id
order by a.courier_id