题目要求：统计出各个title类型对应的员工薪水对应的平均工资avg。结果给出title以及平均工资avg，并且以avg升序排序

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