select *
from dept d
where d.deptno in (
    select e.deptno
    from emp e
    group by e.deptno
        having  count(e.ename) > 0
);