View the Exhibit and examine the description of the EMPLOYEES table. You want to
display the EMPLOYE_ID, FIRST_NAME, and DEPARTMEN_ID for all the employees who
work in the same department and have the same manager as that of the employee having
EMPLOYE_ID 104. To accomplish the task, you execute the following SQL statement:
SELECT employee_id, first_name, department_id FROM employees WHERE (manager_id,
department_id) =(SELECT department_id, manager_id FROM employees WHERE
employee_id = 104) AND employee_id <> 104; When you execute the statement it does not
produce the desired output. What is the reason for this?
A.
The WHERE clause condition in the main query is using the = comparison operator,
instead of EXISTS.
B.
The WHERE clause condition in the main query is using the = comparison operator,
instead of the IN operator.
C.
The WHERE clause condition in the main query is using the = comparison operator,
instead of the = ANY operator.
D.
The columns in the WHERE clause condition of the main query and the columns
selected in the subquery should be in the same order.