The employees table contains salary and bonus percentage.
Return employee_id, bonus_amount, where the bonus is salary * bonus_pct / 100, rounded to 2 decimal places. Sort by employee_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
employees6 rows| employee_id (int) | salary (double) | bonus_pct (double) |
|---|---|---|
| 1 | 50000 | 10 |
| 2 | 62000 | 7.5 |
| 3 | 45000 | 0 |
| 4 | 80000 | 12.5 |
| 5 | 30000 | 20 |
| 6 | 55000 | 5 |
Column names and order must match. Sort order is specified in the question.