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

select 
    a.courier_id,
    courier_name,
    sum(base_salary + ifnull(delivery_fee, 0)) as total_income
from couriers_info a 
left join (
    select
        courier_id,
        sum(delivery_fee) as delivery_fee
    from deliveries_info 
    where date_format(delivery_date, '%Y-%m') = '2024-07'
    group by 1
) b 
on a.courier_id = b.courier_id 
group by 1,2
order by 1
# 避免基础工资加多了