Question

12）查询出每个部门比平均工资高的职工人数。查询语句

Answer 1

select dept1, count(*) from
(select e.dept as dept1,salary from employee e,
(select dept as dept2,avg(salary) as avgsal from employee group by dept) tmp
where e.dept=tmp.dept and e.salary>tmp.svgsal)
group by dept1

Answer 2

你是要查询什么东西哦，是在EXCEL里查询，还是用SQL查询数据库哦。