#181 Employees Earning More Than Their Managers

SELECT Emp.Name AS Employee 
FROM Employee Emp JOIN Employee Mgr
ON Emp.ManagerId = Mgr.Id
WHERE Emp.Salary > Mgr.Salary;

Last updated 3 years ago

Was this helpful?

SELECT Emp.Name AS Employee 
FROM Employee Emp JOIN Employee Mgr
ON Emp.ManagerId = Mgr.Id
WHERE Emp.Salary > Mgr.Salary;