Prev Question
Next Question

View the exhibit and examine the structure of the EMPLOYEES table.

5a2fd83d71d50 - Which SQL statement would you execute?

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 eON 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.manager_id = 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 AND e.manager_id = 100

Prev Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *