By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
1 rows affected
| contract_no | begin_date | end_date | date |
|---|---|---|---|
| aaa | 2020-12-20 | 2021-05-13 | 2020-12-31 |
| aaa | 2020-12-20 | 2021-05-13 | 2021-01-31 |
| aaa | 2020-12-20 | 2021-05-13 | 2021-02-28 |
| aaa | 2020-12-20 | 2021-05-13 | 2021-03-31 |
| aaa | 2020-12-20 | 2021-05-13 | 2021-04-30 |