View the Exhibit and examine the description of the EMPLOYEES table.
You want to display the EMPLOYEE_ID, FIRST_NAME, and DEPARTMENT_ID for all the
employees who work in the same department and have the same manager as that of the
employee having EMPLOYEE_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.