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

MYSQL:

select title,avg(salary)
from titles join salaries
on titles.emp_no=salaries.emp_no
GROUP by title
order by avg(salary);