在oracle中emp表:显示部门人数大于10的每个部门的最高工资?怎么写

在oracle中emp表:显示部门人数大于10的每个部门的最高工资?怎么写

select max(sal+nvl(comm,0)),deptno
from emp
where deptno in(select deptno from emp group by deptno having count(*)>10)
group by deptno;

或是直接
select max(sal+nvl(comm,0)),deptno
from emp
group by deptno
having count(deptno)>10;

（ps:emp表中应该没有哪个部门人数大于10吧！）

select d.deptno, d.dname, count(e.empno) from scott.emp e, scott.dept d where e.deptno = d.deptno group by d.deptno, d.dname having count(e.empno) >= 5; --数字任改