SELECT t.title, avg(s.salary) AS average
FROM titles t
JOIN salaries s
    USING (emp_no)
GROUP BY t.title
ORDER BY average