select tt.title,avg(sal.salary) avg_sal from titles as tt left join salaries as sal on tt.emp_no = sal.emp_no group by tt.title order by avg_sal