employees_earning_more_than_their_managers.sql

SELECT Name AS Employee
FROM
    (SELECT a.Name, a.Salary, b.Salary AS manager_salary
    FROM Employee a
    JOIN Employee b
    ON a.ManagerId = b.Id) AS temp
WHERE salary > manager_salary