Members of one team
Your task
Given staff with columns name, team, salary, hired and manager, and a team name, return the rows for that team. Return only name and team, sorted by name ascending.
Examples
team_members(staff: dataframe, team: str) -> dataframeExample 1
Input
team_members(staff, "eng")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 | team |
|---|---|
| Ada | eng |
| Grace | eng |
| Linus | eng |