Answer-Employees(emp_id, name, salary, mgr_id): (1,'Alice',9000,NULL), (2,'Bob',7000,1), (3,'Carol',9500,1)...

This self-join pairs each employee E with their manager M via mgrid empid, then filters for employees earning more than their own manager. Bob 7000 reports to Alice 9000 7000 9000 is false, so Bob is excluded. Carol 9500 reports to Alice 9000 9500 9000 is true, so Carol is included. Dave 6000 reports to Bob 7000 6000 7000 is false, so Dave is excluded. Alice has no manager mgrid is NULL, so she never appears as E in this join at all. Only Carol satisfies the condition.

Question

Employees(emp_id, name, salary, mgr_id): (1,'Alice',9000,NUL

L , (2,'Bob',7000,1), (3,'Carol',9500,1), (4,'Dave',6000,2). What does the following self-join query return? SELECT E.name FROM Employees E JOIN Employees M ON E.mgr_id = M.emp_id WHERE E.salary > M.salary;

A Bob only

B Carol and Dave

C Carol only

D All employees except Alice

E No rows are returned

Practice Next