select c.courier_id
, courier_name
, sum(base_salary+delivery_fee ) total_income
from couriers_info c
left join 
(select courier_id,sum(delivery_fee) delivery_fee
from deliveries_info
where month(delivery_date) = 7
group by 1
) d
on c.courier_id = d.courier_id
group by 1,2