select distinct c.courier_id
,courier_name
,base_salary + total_delivery_fee as total_income
from couriers_info c
join (
    select courier_id
    ,sum(delivery_fee) over(partition by courier_id) as total_delivery_fee
    from deliveries_info
    where substring(delivery_date,1,7) = "2024-07"
) d on c.courier_id = d.courier_id
order by courier_id