Ta老师题库
数据库：抽出部门，平均工资，要求按部门的字符串顺
10 查阅
参考答案:
select depart_name, avg(wage)
\r\n
from employee
where depart_name <> 'human resource'
group by depart_name
order by depart_name
参考答案:
select depart_name, avg(wage)
\r\n
from employee
where depart_name <> 'human resource'
group by depart_name
order by depart_name