By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
year | group | subgroup | items_1 | set_item_1 | items_2 | set_item_2 |
---|---|---|---|---|---|---|
2020 | G001 | G001-001 | 9 | 0 | 2 | 4 |
2020 | G001 | G001-002 | 5 | 0 | 2 | 4 |
2020 | G001 | G001-003 | 4 | 0 | 4 | 0 |
2020 | G002 | G002-001 | 8 | 3 | 1 | 0 |
2020 | G002 | G002-002 | 8 | 3 | 2 | 0 |
2020 | G002 | G002-003 | 8 | 3 | 3 | 0 |
2021 | G001 | G001-001 | 2 | 0 | 2 | 1 |
2021 | G001 | G001-002 | 5 | 1 | 2 | 1 |
2021 | G001 | G001-003 | 5 | 1 | 3 | 2 |
2021 | G001 | G001-004 | 5 | 1 | 3 | 2 |
2021 | G001 | G001-005 | 1 | 0 | 3 | 2 |
2021 | G002 | G002-001 | 3 | 2 | 4 | 3 |
2021 | G002 | G002-002 | 3 | 2 | 4 | 3 |
2021 | G003 | G003-001 | 7 | 0 | 1 | 0 |
year | group | sum_items_1 | sum_items_2 |
---|---|---|---|
2021 | G001 | 8 | 5 |
2021 | G002 | 3 | 4 |
2021 | G003 | 7 | 1 |
2020 | G001 | 18 | 6 |
2020 | G002 | 8 | 6 |