| ID |
CustomerID |
SomeDate |
| 1 |
1000 |
2022-06-10 |
| 2 |
1000 |
2022-06-17 |
| 3 |
1000 |
2022-06-22 |
| 4 |
1000 |
2022-06-26 |
| 5 |
1000 |
2022-07-01 |
| 6 |
1000 |
2022-07-07 |
| 7 |
1000 |
2022-07-17 |
| ID |
CustomerID |
StartDate |
EndDate |
SomeValue |
| A |
1000 |
2022-06-01 |
2022-06-15 |
225 |
| B |
1000 |
2022-06-16 |
2022-06-20 |
400 |
| C |
1000 |
2022-06-21 |
2022-06-29 |
350 |
| D |
1000 |
2022-07-02 |
2022-07-09 |
500 |
| ID |
CustomerID |
SomeDate |
SomeValue |
| 1 |
1000 |
2022-06-10 |
225 |
| 2 |
1000 |
2022-06-17 |
400 |
| 3 |
1000 |
2022-06-22 |
350 |
| 4 |
1000 |
2022-06-26 |
350 |
| 5 |
1000 |
2022-07-01 |
0 |
| 6 |
1000 |
2022-07-07 |
500 |
| 7 |
1000 |
2022-07-17 |
0 |