题解 | #统计员工当前薪水对应的平均工资#

select title,avg (salaries.salary) as avg_salary
from titles,salaries
where titles.emp_no = salaries.emp_no
group by title
order by avg_salary