/*
Wyswietl dane o pracown. osiag. zarobki w wys. 36000 oraz na stan. 'CLERK'
*/
select  ename,
        job,
	sal*12+nvl(comm,0) "Roczny zarobek",
	d.deptno,
	dname,
	grade
from emp e, salgrade, dept d
where e.deptno=d.deptno
  and sal between losal and hisal
  and (sal*12+nvl(comm,0)=36000 or e.job='CLERK')
order by e.job;

