The employees table contains employee IDs and manager IDs. Managers are also employees, but some employees have no manager on record.
Return employee_id, employee_name for employees whose manager_id is null. Sort by employee_id ascending.
These DataFrames are passed to solve(spark, dfs). Access one with dfs['name'].
employees5 rows| employee_id (int) | employee_name (string) | manager_id (int) |
|---|---|---|
| 1 | Aarav | null |
| 2 | Bela | 1 |
| 3 | Chen | 1 |
| 4 | Dia | null |
| 5 | Eli | 3 |
Column names and order must match. Sort order is specified in the question.