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