By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| ReasonId | Team | TotalByTeam | Division | TotalByDivision | Location | TotalByLocation |
|---|---|---|---|---|---|---|
| 2 | A | 3 | null | 0 | L1 | 2 |
| 3 | B | 1 | D1 | 1 | L2 | 1 |
| 2 | A | 3 | D2 | 1 | L1 | 2 |
| 2 | A | 3 | D3 | 1 | L3 | 1 |
| ReasonId | Team | TotalByTeam | Division | TotalByDivision | Location | TotalByLocation |
|---|---|---|---|---|---|---|
| 2 | A | 3 | null | 0 | L1 | 2 |
| 3 | B | 1 | D1 | 1 | L2 | 1 |
| 2 | A | 3 | D2 | 1 | L1 | 2 |
| 2 | A | 3 | D3 | 1 | L3 | 1 |