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

简单，考察分组