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 name = 'carrey');