Calculate Special Bonus II
ASKED IN INTERVIEWApple
Problem Statement
Apple HR is implementing a new performance-based bonus structure. The bonus for an employee is 50% of their salary if:
- Their employee ID is an even number.
- The length of their name is strictly greater than 5 characters.
If these conditions are not met, the bonus is 0.
Rules:
- Output columns: employee_id, bonus.
- Results must be sorted by employee_id in ascending order.
Tests your understanding of
Conditional Logic, String Functions and Arithmetic
Input Tables
employees
| employee_id(INTEGER) | name(VARCHAR) | salary(INTEGER) |
|---|---|---|
| 2 | Meghan | 3000 |
| 3 | Addison | 3800 |
| 7 | Kody | 7400 |
| 8 | Adryan | 6100 |
| 9 | Arun | 3400 |
employee_benefits
| employee_id(INTEGER) | has_insurance(BOOLEAN) |
|---|---|
| 2 | true |
| 8 | false |
departments
| dept_id(INTEGER) | employee_id(INTEGER) |
|---|---|
| 1 | 2 |
| 2 | 8 |
Expected Output
| employee_id(INTEGER) | bonus(DECIMAL) |
|---|---|
| 2 | 1500 |
| 3 | 0 |
| 7 | 0 |
| 8 | 3050 |
| 9 | 0 |
Tags
EasyASKED IN INTERVIEWConditional LogicString FunctionsArithmetic
10-15 min
84%