select title, avg(salary)
from titles a join salaries b on a.emp_no=b.emp_no
group by title
order by avg(salary)