select title,AVG(salary)as 'avg' from titles, salaries where titles.emp_no = salaries.emp_no group by(title) order by 'avg' ASC
需要善用函数，理清思路