181. Leetcode Solution in Mysql

# Write your MySQL query statement below


SELECT E1.Name as 'Employee'
FROM Employee as E1, Employee as E2
WHERE E1.ManagerId = E2.Id AND E1.Salary > E2.Salary;

leetcode

challenge

here is the link for the problem:
https://leetcode.com/problems/employees-earning-more-than-their-managers/