select courier_id,courier_name,(base_salary+sum(delivery_fee)-sum_expense_amount) as total_income
from couriers_info c join deliveries_info d using(courier_id) join (select courier_id,sum(expense_amount) as sum_expense_amount
from expenses_info
where expense_date between '2024-07-01' and '2024-07-31'
group by courier_id) e using(courier_id)
where delivery_date between '2024-07-01' and '2024-07-31'
group by courier_id
order by courier_id