select t.title, avg(s.salary)
from salaries s join titles t using(emp_no)

group by t.title
order by avg(s.salary)