00:00:00

Description

Editorial

Rule-Based Employee Bonus Allocation

EASY10 pts

A compensation analytics service applies a deterministic bonus policy to monthly payroll records.

Table: employees

employee_id: unique identifier for each employee
name: employee display name
salary: monthly base salary

Bonus policy:

bonus equals salary only when both conditions are true:
1. employee_id is odd
2. name does not start with the uppercase character 'M'
Otherwise, bonus is 0.

Task: Return each employee with their computed bonus according to the policy.

Output requirements:

Return exactly two columns:
- employee_id
- bonus
Sort rows by employee_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

employees:
| employee_id | name    | salary |
|-------------|---------|--------|
| 2           | Meir    | 3000   |
| 3           | Michael | 3800   |
| 7           | Addilyn | 7400   |
| 8           | Juan    | 6100   |
| 9           | Kannon  | 7700   |

Output

[
  {"employee_id":2,"bonus":0},
  {"employee_id":3,"bonus":0},
  {"employee_id":7,"bonus":7400},
  {"employee_id":8,"bonus":0},
  {"employee_id":9,"bonus":7700}
]

Explanation

Only odd employee IDs with names not starting with uppercase M receive full salary as bonus.

Example

Input

employees:
| employee_id | name   | salary |
|-------------|--------|--------|
| 1           | maria  | 4200   |
| 4           | Olivia | 3900   |
| 5           | Mason  | 5100   |
| 11          | Noah   | 4700   |

Output

[
  {"employee_id":1,"bonus":4200},
  {"employee_id":4,"bonus":0},
  {"employee_id":5,"bonus":0},
  {"employee_id":11,"bonus":4700}
]

Explanation

The lowercase name maria is eligible because only uppercase M as the first character is disqualifying.

Example

Input

employees:
| employee_id | name | salary |
|-------------|------|--------|
| (no rows)   |

Output

[]

Explanation

An empty input table produces an empty output table.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in employees <= 100000
1 <= employee_id <= 1000000000
employee_id is unique
1 <= length(name) <= 30
0 <= salary <= 1000000
Return exactly two columns: employee_id, bonus
Sort by employee_id ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: employee_id, bonus

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employees =

[{"employee_id":2,"name":"Meir","salary":3000},{"employee_id":3,"name":"Michael","salary":3800},{"employee_id":7,"name":"Addilyn","salary":7400},{"employee_id":8,"name":"Juan","salary":6100},{"employee_id":9,"name":"Kannon","salary":7700}]

Loading problem...

101

00:00:00

Description

Editorial

Rule-Based Employee Bonus Allocation

EASY10 pts

A compensation analytics service applies a deterministic bonus policy to monthly payroll records.

Table: employees

employee_id: unique identifier for each employee
name: employee display name
salary: monthly base salary

Bonus policy:

bonus equals salary only when both conditions are true:
1. employee_id is odd
2. name does not start with the uppercase character 'M'
Otherwise, bonus is 0.

Task: Return each employee with their computed bonus according to the policy.

Output requirements:

Return exactly two columns:
- employee_id
- bonus
Sort rows by employee_id in ascending order.

Supported submission environments:

SQL (SQLite 3.27.2)
Pandas (Python)

Example

Input

employees:
| employee_id | name    | salary |
|-------------|---------|--------|
| 2           | Meir    | 3000   |
| 3           | Michael | 3800   |
| 7           | Addilyn | 7400   |
| 8           | Juan    | 6100   |
| 9           | Kannon  | 7700   |

Output

[
  {"employee_id":2,"bonus":0},
  {"employee_id":3,"bonus":0},
  {"employee_id":7,"bonus":7400},
  {"employee_id":8,"bonus":0},
  {"employee_id":9,"bonus":7700}
]

Explanation

Only odd employee IDs with names not starting with uppercase M receive full salary as bonus.

Example

Input

employees:
| employee_id | name   | salary |
|-------------|--------|--------|
| 1           | maria  | 4200   |
| 4           | Olivia | 3900   |
| 5           | Mason  | 5100   |
| 11          | Noah   | 4700   |

Output

[
  {"employee_id":1,"bonus":4200},
  {"employee_id":4,"bonus":0},
  {"employee_id":5,"bonus":0},
  {"employee_id":11,"bonus":4700}
]

Explanation

The lowercase name maria is eligible because only uppercase M as the first character is disqualifying.

Example

Input

employees:
| employee_id | name | salary |
|-------------|------|--------|
| (no rows)   |

Output

[]

Explanation

An empty input table produces an empty output table.

Accepted0/0·0% Acceptance

Constraints

0 <= number of rows in employees <= 100000
1 <= employee_id <= 1000000000
employee_id is unique
1 <= length(name) <= 30
0 <= salary <= 1000000
Return exactly two columns: employee_id, bonus
Sort by employee_id ascending
For SQL submissions, use SQLite 3.27.2 semantics
For Pandas submissions, return a DataFrame with columns: employee_id, bonus

Code

Visualizer

Solutions

14px

Test Cases3

Results

Submissions

employees =

Rule-Based Employee Bonus Allocation

Hints

Rule-Based Employee Bonus Allocation

Hints