00:00:00

Description

Editorial

Reports Paid More Than Their Managers

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employee =

[{"id":1,"name":"Ira","salary":68000,"managerId":3},{"id":2,"name":"Noah","salary":76000,"managerId":4},{"id":3,"name":"Ravi","salary":65000,"managerId":null},{"id":4,"name":"Mina","salary":90000,"managerId":null}]

Loading problem...

101

00:00:00

Description

Editorial

Reports Paid More Than Their Managers

EASY10 pts

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

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

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

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.

Accepted0/0·0% Acceptance

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

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employee =

Reports Paid More Than Their Managers

Hints

Reports Paid More Than Their Managers

Hints