Employee Bonus Visualizer & Solution | Rulcode

316. Employee Bonus

Medium

Topics

Hint

Input:

Employee table:

empId	name	supervisor	salary
3	Brad	null	4000
1	John	3	1000
2	Dan	3	2000
4	Thomas	3	4000

Bonus table:

empId	bonus
2	500
4	2000

Output:

Explanation:

Let's analyze each employee:

Brad (empId 3): No entry in the Bonus table. Thus, he qualifies because he did not get any bonus. Output: Brad, null.
John (empId 1): No entry in the Bonus table. Thus, he qualifies because he did not get any bonus. Output: John, null.
Dan (empId 2): Has a bonus of 500. Since 500 is less than 1000, he qualifies. Output: Dan, 500.
Thomas (empId 4): Has a bonus of 2000. This is not less than 1000, and he did get a bonus. Thus, he does not qualify.

The final output includes Brad, John, and Dan with their respective bonus amounts (or null if no bonus).

Loading problem details...