Employees Earning More Than Their Managers LeetCode Solution

Last updated on January 22nd, 2025 at 11:22 pm

Here, we see the Employees Earning More Than Their Managers LeetCode Solution. This Leetcode problem is solved using MySQL and Pandas.

List of all LeetCode Solution

Level of Question

Easy

Employees Earning More Than Their Managers LeetCode Solution

Employees Earning More Than Their Managers LeetCode Solution

1. Problem Statement

Column NameType
idint
namevarchar
salaryint
managerIdint
Table: Employee

id is the primary key (column with unique values) for this table. Each row of this table indicates the ID of an employee, their name, salary, and the ID of their manager.

Write a solution to find the employees who earn more than their managers.

Return the result table in any order.

The result format is in the following example.

Example 1:
Input:

idnamesalary managerId
1Joe700003
2Henry800004
3Sam60000Null
4Max90000Null
Employee table:

Output:

Employee
Joe

Explanation: Joe is the only employee who earns more than his manager.

2. Code Implementation in Different Languages

2.1 Employees Earning More Than Their Managers MySQL

select 
  e.Name as Employee 
from 
  Employee as e 
  inner join Employee as m on e.ManagerId = m.id 
where 
  e.Salary > m.Salary;
Scroll to Top