select
title,avg(salary) 
from (
    select 
    b.emp_no,b.salary,a.title
    from  titles a
    left  join  salaries b
    on  a.emp_no  =  b.emp_no
)h
group by   title
order by   avg(salary)