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.