Which DELETE statement is valid?

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

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

B.
DELETE * FROM employees WHERE employee_id IN(SELECT employee_id FROM
new_employees WHERE last_name = ‘Carrey’);

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

D.
DELETE FROM employees WHERE employee_id IN(SELECT employee_id FROM
new_employees WHERE name = ‘Carrey’);