select A.title, avg(B.salary)
from titles A
left join salaries B 
on A.emp_no = B.emp_no
group by A.title
order by  avg(B.salary) ASC