Pracownicy posiadajacy podwladnych;

select ename, job, deptno
from emp e
where exists (	 select empno
		 from emp where emp.mgr=e.empno)

order by deptno;
