By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| min_id | max_id | min_date | max_date | streak_length |
|---|---|---|---|---|
| 1 | 2 | 2017-08-01 | 2017-08-02 | 2 |
| 4 | 6 | 2017-08-04 | 2017-08-06 | 3 |
| min_id | max_id | min_date | max_date | streak_length |
|---|---|---|---|---|
| 1 | 2 | 2017-08-01 | 2017-08-02 | 2 |
| 4 | 6 | 2017-08-04 | 2017-08-06 | 3 |