By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
20 rows affected
| ID | A | B | C | ROW_AFTER_NEXT_MATCH | NUM_MATCHES |
|---|---|---|---|---|---|
| 1 | 1 | 0 | 0 | null | 0 |
| 2 | 1 | 0 | 0 | null | 0 |
| 3 | 0 | 1 | 0 | null | 0 |
| 4 | 1 | 0 | 0 | null | 0 |
| 5 | 0 | 1 | 0 | null | 1 |
| 6 | 0 | 0 | 1 | 12 | 2 |
| 7 | 1 | 0 | 0 | 13 | 2 |
| 8 | 0 | 1 | 0 | null | 1 |
| 9 | 1 | 0 | 0 | null | 1 |
| 10 | 0 | 1 | 0 | null | 1 |
| 11 | 0 | 0 | 1 | null | 2 |
| 12 | 1 | 0 | 0 | null | 2 |
| 13 | 1 | 0 | 0 | null | 1 |
| 14 | 1 | 0 | 0 | null | 1 |
| 15 | 1 | 0 | 0 | null | 1 |
| 16 | 1 | 0 | 0 | 18 | 5 |
| 17 | 1 | 0 | 0 | 19 | 5 |
| 18 | 1 | 0 | 0 | 20 | 5 |
| 19 | 1 | 0 | 0 | 21 | 5 |
| 20 | 1 | 0 | 0 | null | 5 |