题目

image.png

建表语句

  1. Create table If Not Exists Employee (id int, name varchar(255), salary int, managerId int)
  2. Truncate table Employee
  3. insert into Employee (id, name, salary, managerId) values ('1', 'Joe', '70000', '3')
  4. insert into Employee (id, name, salary, managerId) values ('2', 'Henry', '80000', '4')
  5. insert into Employee (id, name, salary, managerId) values ('3', 'Sam', '60000', 'None')
  6. insert into Employee (id, name, salary, managerId) values ('4', 'Max', '90000', 'None')

解题思路

搞成两个表

SQL代码

SELECT
    a.Name AS 'Employee'
FROM
    Employee AS a,
    Employee AS b
WHERE
    a.ManagerId = b.Id
        AND a.Salary > b.Salary
;