Problem 181

Employee earning more than their manager

Posted by Ruizhi Ma on July 1, 2019

问题描述

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

代码

# Write your MySQL query statement below
SELECT tb1.Name as Employee
FROM Employee as tb1
LEFT JOIN Employee as tb2
ON tb1.ManagerId = tb2.Id
Where tb1.Salary > tb2.Salary;