Everyone earning more than their manager
Your task
Given staff with columns name, team, salary, hired and manager, where manager holds another employee name or null, return the people who earn strictly more than their manager. Return name and manager, sorted by name ascending.
Examples
outearns_manager(staff: dataframe) -> dataframeExample 1
Input
outearns_manager(staff)staff
More rows not shown
| name | team | salary | hired | manager |
|---|---|---|---|---|
| Ada | eng | 120 | 2021-03-01 | Grace |
| Grace | eng | 150 | 2019-06-15 | NULL |
| Linus | eng | 95 | 2022-01-10 | Grace |
| Mel | sales | 80 | 2020-11-05 | Kay |
| Kay | sales | 110 | 2018-02-20 | NULL |
| Ivan | sales | 80 | 2023-07-01 | Kay |
| Jean | design | 105 | 2021-09-30 | NULL |
| Nia | design | 140 | 2022-05-04 | Jean |
Output
| name | manager |
|---|---|
| Nia | Jean |
| Omar | Kay |