By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| NEW_DATE | CLIENT_ID | OPEN_DATE | CLOSE_DATE |
|---|---|---|---|
| 01-JAN-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-FEB-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-MAR-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-APR-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-MAY-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-JUN-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-JUL-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-AUG-20 | 1 | 01-JAN-20 | 06-JUN-20 |
| 01-SEP-20 | 1 | 01-JAN-20 | 06-JUN-20 |