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