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