By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| date | flag |
|---|---|
| 20181031 | V |
| 20181130 | V |
| 20181231 | V |
| 20190131 | F |
| 20190228 | F |
| 20190331 | F |
| 20190430 | F |
| 20190531 | V |
| 20190630 | V |
| 20190731 | V |
| date | flag | seqnum | seqnum_2 | cnt |
|---|---|---|---|---|
| 20181031 | V | 1 | 1 | 1 |
| 20181130 | V | 2 | 2 | 2 |
| 20181231 | V | 3 | 3 | 3 |
| 20190131 | F | 4 | 1 | 1 |
| 20190228 | F | 5 | 2 | 2 |
| 20190331 | F | 6 | 3 | 3 |
| 20190430 | F | 7 | 4 | 4 |
| 20190531 | V | 8 | 4 | 1 |
| 20190630 | V | 9 | 5 | 2 |
| 20190731 | V | 10 | 6 | 3 |