select a.title, AVG(b.salary) as 'avg(s.salary)'
from titles as a
left join salaries as b
on a.emp_no = b.emp_no
group by a.title
order by 'avg(s.salary)';