编辑代码

CREATE DATABASE test;
use test;
CREATE TABLE Employee (
	id int,
    name varchar(255),
	salary int,
    managerId int
);

INSERT INTO Employee VALUES (1,'Joe' ,70000, 3);
INSERT INTO Employee VALUES (2, 'Henry',80000,4);
INSERT INTO Employee VALUES (3, 'Sam',60000,null);
INSERT INTO Employee VALUES (4, 'Max',90000,null);

select e2.name as Employee from Employee as e1 inner join 
Employee as e2 on e1.id=e2.managerId 
where e2.salary>e1.salary
;