数据库：查找员工表,显示部门名字和平均工资，要求按平均工资升序显示，并且不需要统计含有"HR"的部门，

Question

employee表结构如下：employee_id, employee_name, depart_id,depart_name,wage[工资]

Answer 1

select depart_name,avg(wage) as avg_wage
from employee
group by depart_id
order by avg_wage;
感觉你这表设计的好怪呀追问

不包含“HR”部门没写啊- -

追答

那得知道你：HR的部门是名是什么？或者id是多少？加fromr子句后加下where 条件 如：where depart_name 'HR部门'或depart_id'HR部门的ID'
select depart_name,avg(wage) as avg_wage
from employee
where depart_name !='HR部门'
group by depart_id
order by avg_wage;