By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| id | type | variety | cnt_type | year |
|---|---|---|---|---|
| 1 | orange | 5 | Box | 2020 |
| 1 | orange | 5 | Package | null |
| 1 | orange | 5 | Package | null |
| 2 | orange | 7 | Box | 2015 |
| 2 | orange | 7 | Package | null |
| 3 | apple | 1 | Box | 2020 |
| 3 | apple | 1 | Package | null |
| 4 | apple | 0 | Box | null |
| 4 | apple | 0 | Package | null |