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

select
    c.courier_id,
    c.courier_name,
    (c.base_salary + d.total_fee) as total_income
from
    couriers_info c join (
        select
            courier_id,
            ifnull(sum(delivery_fee), 0) as total_fee
        from
            deliveries_info
        where 
            extract(year_month from delivery_date) = '202407'
        group by
            courier_id) d
    on c.courier_id = d.courier_id
order by
    c.courier_id;