By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
4 rows affected
| cust_id | open_date | closed_date |
|---|---|---|
| a123 | 2019-10-01 | 2019-11-01 |
| b245 | 2019-07-01 | 2019-09-15 |
| b245 | 2019-10-12 | 2019-12-01 |
4 rows affected
| cust_id | open_date | closed_date |
|---|---|---|
| a123 | 2019-10-01 | 2019-11-01 |
| b245 | 2019-07-01 | 2019-09-15 |
| b245 | 2019-10-12 | 2019-12-01 |