By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
6 rows affected
| transaction_id | transaction_type | spend_year | transaction_date | spend_year_start_date | spend_year_end_date |
|---|---|---|---|---|---|
| 1 | New Business | 0 | 2020-11-01 | 2020-11-01 | 2021-07-15 |
| 2 | Supplemental | 0 | 2021-08-23 | 2020-11-01 | 2021-07-15 |
| 3 | Renewal | 1 | 2021-10-15 | 2021-07-15 | 2022-04-15 |
| 4 | Supplemental | 1 | 2022-02-01 | 2021-07-15 | 2022-04-15 |
| 5 | Supplemental | 1 | 2022-05-22 | 2021-07-15 | 2022-04-15 |
| 6 | Renewal | 2 | 2022-07-15 | 2022-04-15 | null |