Budgets nobody is spending
Your task
Given staff with columns name, team, salary, hired and manager, and budgets with columns team and budget, return the budget rows whose team has no employees. Return team and budget, sorted by team ascending.
Examples
unspent_budgets(staff: dataframe, budgets: dataframe) -> dataframeExample 1
Input
unspent_budgets(staff, budgets)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 |
budgets
| team | budget |
|---|---|
| eng | 900 |
| sales | 400 |
| ops | 250 |
Output
| team | budget |
|---|---|
| ops | 250 |