select

a.title,avg(b.salary)

from 
titles a 

join salaries b
using(emp_no)

group by a.title 
order by avg(b.salary) asc