By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| Id | xDate | Value |
|---|---|---|
| 1 | 2021-01-01 | 100 |
| 1 | 2021-01-02 | 100 |
| 1 | 2021-01-03 | 100 |
| 1 | 2021-12-29 | 100 |
| 1 | 2021-12-30 | 100 |
| 1 | 2021-12-31 | 100 |
| 2 | 2021-01-01 | 100 |
| 2 | 2021-01-02 | 100 |
| 2 | 2021-01-03 | 100 |
| 2 | 2021-06-01 | 100 |
| 2 | 2021-06-02 | 100 |
| 2 | 2021-06-03 | 100 |
| Id | startDate | endDate | sumValue |
|---|---|---|---|
| 1 | 2021-01-01 | 2021-01-03 | 300 |
| 1 | 2021-12-29 | 2021-12-31 | 300 |
| 2 | 2021-01-01 | 2021-01-03 | 300 |
| 2 | 2021-06-01 | 2021-06-03 | 300 |