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=(SELECT employee_id FROM
new_employees);

C.
DELETE FROM employeesWHERE employee_id IN (SELECT employee_id FROM
new_employees WHERE name = �Carrey�);

D.
DELETE * FROM employeesWHERE employee_id IN (SELECT employee_id FROM
new_employees WHERE name = �Carrey�);