Each team share of payroll
Your task
Given staff with columns name, team, salary, hired and manager, return each team share of total payroll as share, rounded to three decimal places. Return team and share, sorted by team ascending.
Examples
payroll_share(staff: dataframe) -> dataframeExample 1
Input
payroll_share(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 | share |
|---|---|
| design | 0.244 |
| eng | 0.363 |
| sales | 0.393 |