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