21.查询各部门的平均工资，排序.sql

来自「介绍了一些数据库中常用的语句」· SQL 代码 · 共 3 行

select departments.depname,avg(salary)
from employees inner join departments on employees.department=departments.depid
group by departments.depname order by avg(salary)