View the Exhibit and examine the structure of the EMPLOYEES table. You want to display
all employees and their managers having 100 as the MANAGER_ID. You want the output in
two columns: the first column would have the LAST_NAME of the managers and the second
column would have LAST_NAME of the employees. Which SQL statement would you
execute?
A.
SELECT m.last_name “Manager”, e.last_name “Employee” FROM employees m JOIN
employees e ON m.employee_id = e.manager_id WHERE m.manager_id=100;
B.
SELECT m.last_name “Manager”, e.last_name “Employee” FROM employees m JOIN
employees e ON m.employee_id = e.manager_id WHERE e.managerjd=100;
C.
SELECT m.last_name “Manager”, e.last_name “Employee” FROM employees m JOIN
employees e ON e.employee_id = m.manager_id WHERE m.manager_id=100;
D.
SELECT m.last_name “Manager”, e.last_name “Employee” FROM employees m JOIN
employees e WHERE m.employee_id = e.manager_id AND e.managerjd=100;