Given employees, return rows where department = 'Engineering'. Project emp_id, name and order by emp_id ascending.
| emp_id | name | department | is_active |
|---|---|---|---|
| 1 | Riya | Marketing | True |
| 2 | Rohan | HR | False |
| 3 | Nisha | Product | True |
| 4 | Sara | Sales | True |
| 5 | Aanya | Product | False |
| 6 | Tara | Sales | True |
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
employees10 rows| emp_id (int) | name (string) | department (string) | is_active (boolean) |
|---|---|---|---|
| 1 | Riya | Marketing | true |
| 2 | Rohan | HR | false |
| 3 | Nisha | Product | true |
| 4 | Sara | Sales | true |
| 5 | Aanya | Product | false |
| 6 | Tara | Sales | true |
| 7 | Vivaan | Finance | true |
| 8 | Meera | Finance | true |
| 9 | Priya | Finance | true |
| 10 | Kian | Support | true |
Column names and order must match. Sort order is specified in the question.