corrected by myself select deptno, sum(sal) as tsal from scott.emp a where job in ('SALESMAN','CLERK') group by a.deptno;
select deptno,sum(sal) as tsal from scott.emp a group by a.deptno having job in 'salesman' and 'clerk;
Separate names with a comma.