View the Exhibit and examine the structure of the EMPLOYEES table.
You want to know the FIRST_NAME and SALARY for all employees who have the same manager
as that of the employee with the first name ‘Neena’ and have salary equal to or greater than that
of’Neena’.
Which SQL statement would give you the desired result?
A.
SELECTfirst_name, salary
FROM employees
WHERE (manager_id, salary) >= ALL (SELECT manager_id, salary FROM employees WHERE
first_name = ‘Neena’) AND first_name <> ‘Neena’;
B.
SELECTfirst_name, salary
FROM employees
WHERE (manager_id, salary) >= (SELECT manager_id, salary
FROM employees
WHERE first_name = ‘Neena’)
AND first_name <> ‘Neena’;
C.
SELECT first_name, salary
FROM employees
WHERE (manager_id, salary) >= ANY (SELECT manager_id, salary FROM employees WHERE
first_name = ‘Neena’ AND first_name <> ‘Neena’;
D.
SELECT first_name, salary FROM employees
WHERE (manager_id = (SELECT manager_id
FROM employees
WHERE first_name = ‘Neena’)
AND salary >= (SELECT salary
FROM employees
WHERE first_name = ‘Neena’))
AND first name <> ‘Neena’;