SELECT deptno "Abteilung" FROM emp

SELECT deptno FROM emp WHERE job = 'PRESIDENT';