select t.title, avg(s.salary)
from titles t
left join
salaries s
on t.emp_no=s.emp_no
group by t.title
order by avg(s.salary)

考察连接还有分组聚合