Given a employees DataFrame, return rows where salary > 100000. Project the columns emp_id, name, salary and order by emp_id ascending.
employees| emp_id | name | department | salary |
|---|---|---|---|
| 1 | Zara | Support | 119161 |
| 2 | Dev | Support | 185810 |
| 3 | Nisha | Ops | 149591 |
| 4 | Rohan | Sales | 100762 |
| 5 | Nisha | Sales | 45904 |
| 6 | Mira | Finance | 199640 |
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
employees10 rows| emp_id (int) | name (string) | department (string) | salary (int) |
|---|---|---|---|
| 1 | Zara | Support | 119161 |
| 2 | Dev | Support | 185810 |
| 3 | Nisha | Ops | 149591 |
| 4 | Rohan | Sales | 100762 |
| 5 | Nisha | Sales | 45904 |
| 6 | Mira | Finance | 199640 |
| 7 | Reyansh | Data | 104605 |
| 8 | Dev | Design | 120965 |
| 9 | Aarav | Data | 123182 |
| 10 | Anaya | Ops | 60695 |
Column names and order must match. Sort order is specified in the question.