-- Oracle的EMP和DEPT表查询的，如有问题请继续追问select e.deptno as "部门号",d.dname as "部门名",count(e.deptno) as "人数" from emp e, dept d where e.deptno = d.deptno and e.sal > (select avg(sal) from emp) group by e.deptno,d.dname;
