统计出当前各个title类型对应的员工当前薪水对应的平均工资

select title, avg(salary) as  avg from titles inner join salaries on titles.emp_no =salaries.emp_no group by titles.title  order by  avg asc

先连接俩张表，然后再进行分组，算平均分