By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| id | year | amount |
|---|---|---|
| 1 | 2016 | 0 |
| 1 | 2017 | 200 |
| 1 | 2018 | 0 |
| 1 | 2019 | 300 |
| 1 | 2020 | 0 |
| 2 | 2016 | 0 |
| 2 | 2017 | 0 |
| 2 | 2018 | 0 |
| 2 | 2019 | 0 |
| 2 | 2020 | 0 |
8 rows affected
| id | year | amount |
|---|---|---|
| 1 | 2016 | 0 |
| 1 | 2017 | 200 |
| 1 | 2018 | 0 |
| 1 | 2019 | 300 |
| 1 | 2020 | 0 |
| 2 | 2016 | 0 |
| 2 | 2017 | 0 |
| 2 | 2018 | 0 |
| 2 | 2019 | 0 |
| 2 | 2020 | 0 |