力扣SQL刷题3

题目

解题思路：
方法一：自连接

select e.Name 'Employee'
from Employee e,Employee e1
where  e.managerId = e1.Id and e.salary > e1.salary;

方法二：左连接

select e.Name as Employee
from Employee e
left join Employee e1 
 on e.ManagerId = e1.Id 
where e.Salary > e1.Salary;