Který INSERT správně zkopíruje POUZE zaměstnance z oddělení 50 (departmentid=50) do tabulky emp50?

Question

Answer

CREATE TABLE emp50 AS SELECT * FROM employees WHERE departmentid = '50';

Answer

CREATE TABLE emp50 AS SELECT * FROM employees; DELETE FROM emp50 WHERE departmentid <> 50;

Answer

CREATE TABLE emp50 AS SELECT * FROM employees WHERE departmentid = 50;

Answer

INSERT INTO emp50 SELECT * FROM employees WHERE departmentid = 50;

Crowdly