Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables:<br /> 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');