select title, avg(salary)
/建立一个subquery来查询title,avg(salary)/
from (select t.title, s.salary
from titles as t
left join salaries as s
on t.emp_no = s.emp_no) as subquery
/*不要忘记用group by分组title */
group by title
order by avg(salary);