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