Headcount per team
Your task
Given staff with columns name, team, salary, hired and manager, return the number of people on each team in a column named n. Return team and n, sorted by team ascending.
Examples
headcount(staff: dataframe) -> dataframeExample 1
Input
headcount(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 | n |
|---|---|
| design | 2 |
| eng | 3 |
| sales | 4 |