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=(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’);