with t1 as (
    select delivery_id,courier_id,delivery_date,delivery_fee
    from deliveries_info d
    where mid(delivery_date,1,7) = '2024-07'
)
select t1.courier_id,courier_name,sum(delivery_fee)+base_salary total_income
from t1 join couriers_info c on t1.courier_id = c.courier_id
group by t1.courier_id