Sort by team, then pay descending
Your task
Given staff with columns name, team, salary, hired and manager, return every row sorted by team ascending, then salary descending, then name ascending. Return name, team and salary.
Examples
by_team_then_pay(staff: dataframe) -> dataframeExample 1
Input
by_team_then_pay(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
More rows not shown
| name | team | salary |
|---|---|---|
| Nia | design | 140 |
| Jean | design | 105 |
| Grace | eng | 150 |
| Ada | eng | 120 |
| Linus | eng | 95 |
| Omar | sales | 125 |
| Kay | sales | 110 |
| Ivan | sales | 80 |