[bashainfi]

corrected by myself

select deptno, sum(sal) as tsal
from scott.emp a
where job in ('SALESMAN','CLERK')
group by a.deptno;