0181. Employees Earning More Than Their Managers
Description
+-------------+---------+
| Column Name | Type |
+-------------+---------+
| Id | int |
| Name | varchar |
| Salary | int |
| ManagerId | int |
+-------------+---------+
Id is the primary key column for this table.
Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager.**Input:**
Employee table:
+----+-------+--------+-----------+
| Id | Name | Salary | ManagerId |
+----+-------+--------+-----------+
| 1 | Joe | 70000 | 3 |
| 2 | Henry | 80000 | 4 |
| 3 | Sam | 60000 | Null |
| 4 | Max | 90000 | Null |
+----+-------+--------+-----------+
**Output:**
+----------+
| Employee |
+----------+
| Joe |
+----------+
**Explanation:** Joe is the only employee who earns more than his manager.ac
Last updated