Выберите синтаксически правильные, но не обязательно - Ответ на вопрос по информатике №1204879

Вопрос

• SELECT ename, dname FROM emp, dept WHERE emp.deptno=dept.deptno AND dept.loc IN (SELECT loc FROM dept WHERE loc != 'BOSTON')
• SELECT (SELECT deptno FROM emp WHERE ename = 'KING') deptno FROM emp e
• SELECT ename, (SELECT job FROM emp ) job1 FROM emp, JOBWHERE emp.deptno = job1.deptno
• SELECT d.dname, nm.nmb FROM dept d, (SELECT COUNT(*) nmb, deptno FROM emp GROUP BY deptno) nm WHERE d.deptno=nm.deptno

Ответ