Rule-Based Employee Bonus Allocation

Easy

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: employee_id is odd 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 1

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 2

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 3

Input

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

Output

[]

Explanation

An empty input table produces an empty output table.

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

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

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