with
    t1 as (
        select
            courier_id,
            sum(delivery_fee) as total_delivery_fee
        from
            deliveries_info
        where
            date_format(delivery_date, '%Y-%m') = '2024-07'
        group by
            courier_id
    )
select
    courier_id,
    courier_name,
    base_salary + total_delivery_fee as total_income
from
    t1
    join couriers_info using (courier_id)
order by
    courier_id asc;