Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES<br /> EMPLOYEE_ID NUMBER Primary Key<br /> FIRST_NAME VARCHAR2 (25)<br /> LAST_NAME VARCHAR2 (25)<br /> HIRE_DATE DATE<br /> NEW EMPLOYEES<br /> EMPLOYEE_ID NUMBER Primary Key<br /> NAME VARCHAR2 (60)<br /> Which DELETE statement is valid? （）

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

B、DELETE * FROM employees WHERE employee_id = (SELECT employee_id FROM new_ employees);

C、DELETE FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE name = ('Carrey')'

D、DELETE * FROM employees WHERE employee_id IN (SELECT employee_id FROM new_employees WHERE last_ name = ('Carrey')'