SELECT title, avg(s.salary)
FROM titles t
INNER JOIN salaries s on t.emp_no = s.emp_no
GROUP BY title
ORDER BY avg(salary)