[Leetcode] [SQL] Employees earning more Than their Managers

https://leetcode.com/problems/employees-earning-more-than-their-managers/

Employees earning more Than their Managers 

The Employee table holds all employees including their managers. Every employee has an ID, and there is also a column for the manager ID.

+----+-------+--------+-----------+| Id | Name  | Salary | ManagerID |+----+-------+--------+-----------+| 1  | Joe   | 70000  | 3 |         | 2  | Henry | 80000  | 4         | | 3  | Sam   | 60000  | NULL      | | 4  | Max   | 90000  | NULL      |+----+-------+--------+-----------+

Given Employee The table, write a SQL query that finds out employees who earn more than their managers. For the above table, Joe was the only employee of the WHO earns more than his manager.

+----------+| Employee |+----------+| Joe      |+----------+

Select  from where >  and = b.ID

[Leetcode] [SQL] Employees earning more Than their Managers