By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Group | Name | Year | Value | Group | Name | Year | Scope | Status |
|---|---|---|---|---|---|---|---|---|
| 1 | Joe | 2018 | 23 | 1 | Joe | 2018 | 0 | null |
| 1 | Joe | 2019 | 56 | 1 | Joe | 2019 | 78 | Approved |
| 1 | Joe | 2020 | 0 | 1 | Joe | 2020 | 0 | null |
| 1 | Joe | 2021 | 0 | 1 | Joe | 2021 | 0 | null |
| 2 | Fred | 2018 | 0 | 2 | Fred | 2018 | 12 | Approved |
| 2 | Fred | 2019 | 89 | 2 | Fred | 2019 | 0 | null |
| 2 | Fred | 2020 | 45 | 2 | Fred | 2020 | 987 | Started |
| 2 | Fred | 2021 | 0 | 2 | Fred | 2021 | 321 | Sent |