select deptno,sum(sal) as tsal
from scott.emp a
group by a.deptno
having job in 'salesman' and 'clerk;