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