Pay range per team
Your task
Given staff with columns name, team, salary, hired and manager, return the lowest and highest salary on each team as lo and hi. Return team, lo and hi, sorted by team ascending.
Examples
pay_range(staff: dataframe) -> dataframeExample 1
Input
pay_range(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
| team | lo | hi |
|---|---|---|
| design | 105 | 140 |
| eng | 95 | 150 |
| sales | 80 | 125 |