By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| ID | StartDateTime | EndDateTime | Price |
|---|---|---|---|
| 1 | 2024-01-01 | 2024-03-31 | 14.00 |
| 1 | 2024-04-01 | 2024-06-30 | 14.00 |
| 2 | 2024-07-01 | 2024-09-30 | 10.00 |
| 2 | 2024-10-01 | 2024-12-30 | 10.00 |
| 3 | 2023-11-15 | 2023-12-31 | 88.00 |
| 3 | 2024-01-01 | 2024-03-31 | 88.00 |
| 3 | 2024-04-01 | 2024-06-30 | 88.00 |
| 3 | 2024-07-01 | 2024-08-14 | 88.00 |
| 4 | 2024-07-15 | 2024-08-14 | 99.00 |