I have a database with the following records
+--------------+------------+-------------+---------+
| period_start | period_end | customer_id | revenue |
+--------------+------------+-------------+---------+
| 1-1-2023 | 31-3-2023 | 1 | 1000 |
| 1-4-2023 | 30-06-2023 |...