Skip to content

181. Employees Earning More Than Their Managers 👍

1
2
3
4
5
SELECT Worker.name AS Employee
FROM Employee AS Worker
INNER JOIN Employee AS Manager
  ON (Worker.managerId = Manager.id)
WHERE Worker.salary > Manager.salary;