Reports Paid More Than Their Managers

Easy

Your analytics team stores organizational compensation data in a single table: Employee (id, name, salary, managerId) Each row describes one employee: id is the employee identifier name is the employee name salary is the employee salary managerId points to the direct manager's id (or is NULL for top-level leaders) Return all employees whose salary is strictly greater than the salary of their direct manager. Output requirements: Return exactly one column named Employee . Return rows in any order. If managerId is NULL or does not match an existing employee, that row should not appear in the output. Solve this for both: SQL (SQLite 3.27.2) Pandas

Example 1

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 1  | Ira    | 68000  | 3         |
| 2  | Noah   | 76000  | 4         |
| 3  | Ravi   | 65000  | NULL      |
| 4  | Mina   | 90000  | NULL      |

Output

[
  {"Employee":"Ira"}
]

Explanation

Ira earns 68,000 while manager Ravi earns 65,000, so Ira qualifies. Noah does not qualify because manager Mina earns more.

Example 2

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 10 | Leo    | 120000 | 12        |
| 11 | Kim    | 98000  | 12        |
| 12 | Dana   | 100000 | NULL      |
| 13 | Omar   | 130000 | 12        |

Output

[
  {"Employee":"Leo"},
  {"Employee":"Omar"}
]

Explanation

Both Leo and Omar earn more than manager Dana. Kim does not.

Example 3

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 21 | Jia    | 70000  | 22        |
| 22 | Pavel  | 70000  | NULL      |
| 23 | Tariq  | 65000  | 22        |

Output

[]

Explanation

No employee has salary strictly greater than their direct manager.

Constraints

1 <= number of rows in Employee <= 5,000
Employee.id is unique
Employee.salary is an integer in a practical payroll range
Employee.managerId is either NULL or an integer identifier
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with exactly one column: Employee

Loading problem...

Preparing your editor. You can read the problem while it loads.

Reports Paid More Than Their Managers

Easy

Your analytics team stores organizational compensation data in a single table: Employee (id, name, salary, managerId) Each row describes one employee: id is the employee identifier name is the employee name salary is the employee salary managerId points to the direct manager's id (or is NULL for top-level leaders) Return all employees whose salary is strictly greater than the salary of their direct manager. Output requirements: Return exactly one column named Employee . Return rows in any order. If managerId is NULL or does not match an existing employee, that row should not appear in the output. Solve this for both: SQL (SQLite 3.27.2) Pandas

Example 1

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 1  | Ira    | 68000  | 3         |
| 2  | Noah   | 76000  | 4         |
| 3  | Ravi   | 65000  | NULL      |
| 4  | Mina   | 90000  | NULL      |

Output

[
  {"Employee":"Ira"}
]

Explanation

Ira earns 68,000 while manager Ravi earns 65,000, so Ira qualifies. Noah does not qualify because manager Mina earns more.

Example 2

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 10 | Leo    | 120000 | 12        |
| 11 | Kim    | 98000  | 12        |
| 12 | Dana   | 100000 | NULL      |
| 13 | Omar   | 130000 | 12        |

Output

[
  {"Employee":"Leo"},
  {"Employee":"Omar"}
]

Explanation

Both Leo and Omar earn more than manager Dana. Kim does not.

Example 3

Input

Employee:
| id | name   | salary | managerId |
|----|--------|--------|-----------|
| 21 | Jia    | 70000  | 22        |
| 22 | Pavel  | 70000  | NULL      |
| 23 | Tariq  | 65000  | 22        |

Output

[]

Explanation

No employee has salary strictly greater than their direct manager.

Constraints

1 <= number of rows in Employee <= 5,000
Employee.id is unique
Employee.salary is an integer in a practical payroll range
Employee.managerId is either NULL or an integer identifier
Use SQLite 3.27.2 semantics for SQL submissions
For Pandas submissions, return a DataFrame with exactly one column: Employee