Create table Employee 
(
Id int primary key identity(1,1) not null,
Name varchar(255) not null,
Salary int not null,
ManagerId  int  null,
)

insert into Employee(Name,Salary,ManagerId) values('joe',700,3),('Henry',800,4),('Sam',600,Null),('Max',900,Null)


select Name as Employee  from Employee P where   Salary> (select Salary from Employee A where A.Id=P.ManagerId)