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