By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
7 rows affected
| unit | StartDate | EndDate | streak |
|---|---|---|---|
| unit1 | 2023-08-30 | 2023-09-30 | 2 |
| unit2 | 2023-12-30 | 2024-01-30 | 2 |
7 rows affected
| unit | StartDate | EndDate | streak |
|---|---|---|---|
| unit1 | 2023-08-30 | 2023-09-30 | 2 |
| unit2 | 2023-12-30 | 2024-01-30 | 2 |