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

select c.courier_id,
courier_name,
base_salary+delivery total_income
from couriers_info c
join (
    select courier_id, sum(delivery_fee) delivery
    from deliveries_info
    where delivery_date between '2024-07-01' and '2024-07-31'
    group by courier_id   
) d on c.courier_id=d.courier_id
order by c.courier_id