SELECT t.title, AVG(s.salary) 
FROM titles AS t, salaries AS s
WHERE t.emp_no = s.emp_no
GROUP BY t.title
ORDER BY AVG(s.salary) ASC