181. Employees Earning More Than Their Managers

Giới thiệu bài toán

Table: Employee

id is the primary key (column with unique values) for this table.
Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager.

Yêu cầu

Write a solution to find the employees who earn more than their managers.

Return the result table in any order. The result format is in the following example.

Example 1:

id	name	salary	managerId
1	Joe	70000	3
2	Henry	80000	4
3	Sam	60000	Null
4	Max	90000	Null

Employee
Joe

SELECT e.name AS Employee
FROM Employee e
    INNER JOIN Employee m ON e.managerId = m.id
WHERE e.salary > m.salary;