Which DELETE statement is valid?

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which DELETE
statement is valid?

A.
DELETE FROM employeesWHERE employee_id = (SELECT employee_id FROM
employees);

B.
DELETE * FROM employeesWHERE employee_id IN (SELECT employee_idFROM
new_employeesWHERE name = ‘Carrey’);

C.
DELETE * FROM employeesWHERE employee_id=(SELECT employee_id FROM
new_employees);

D.
DELETE FROM employeesWHERE employee_id IN (SELECT employee_idFROM
new_employeesWHERE name = ‘Carrey’);

Explanation: