Which SQL statement would you execute?

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 WHERE m.employee_id = e.manager_id AND e.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 m.manager_id=100;

C.
SELECT m.last_name “Manager”, e.last_name “Employee” FROM employees m JOIN
employees e ON m.employee_id = e.manager_id WHERE e.manager_id=100;

D.
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;