By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| date | value | active_flag |
|---|---|---|
| 202101 | 1 | 0 |
| 202102 | 2 | 0 |
| 202103 | 1 | 0 |
| 202104 | 6 | 0 |
| 202105 | 9 | 0 |
| 202106 | 7 | 1 |
| 202107 | 1 | 0 |
| 202108 | 4 | 0 |
Warning: Null value is eliminated by an aggregate or other SET operation.