Pracownicy zatrudnieni na etatach, gdzie nikt nie pracuje;

select empno, ename, job
from emp e
where not exists 
	( select empno  from emp
	  where job=e.job and empno ! e.empno)

order by job;
