By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| start | finish | group_num |
|---|---|---|
| 1 | 3 | 0 |
| 5 | 9 | 0 |
| 11 | 12 | 0 |
| 18 | 28 | 1 |
| 30 | 33 | 1 |
| 34 | 48 | 1 |
| 55 | 56 | 2 |
| 57 | 58 | 2 |
| 60 | 71 | 2 |
| 74 | 80 | 2 |
| 90 | 92 | 3 |
| 98 | 100 | 4 |
12 rows affected
| start | finish | group_num |
|---|---|---|
| 1 | 3 | 0 |
| 5 | 9 | 0 |
| 11 | 12 | 0 |
| 18 | 28 | 1 |
| 30 | 33 | 1 |
| 34 | 48 | 1 |
| 55 | 56 | 2 |
| 57 | 58 | 2 |
| 60 | 71 | 2 |
| 74 | 80 | 2 |
| 90 | 92 | 3 |
| 98 | 100 | 4 |