1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13

-- @Title: 超过经理收入的员工 (Employees Earning More Than Their Managers)
-- @Author: 15816537946@163.com
-- @Date: 2021-03-03 15:20:06
-- @Runtime: 285 ms
-- @Memory: 0 B
# Write your MySQL query statement below

select 
E1.Name AS Employee
from 
Employee  E1 
Inner join  Employee E2
on  E1.ManagerId = E2.Id and E1.Salary > E2.Salary