How to display dname where at least 3 are working and display only department name?
SELECT DISTINCT d.dnameFROM dept d, emp eWHERE d.deptno=e.deptnoAND 3 >ANY (select count(deptno) FROM emp group by deptno );