By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| WEEK | WSD | START_DATE | END_DATE | STATE | NEW_STATE |
|---|---|---|---|---|---|
| 01 | 31-DEC-18 | null | null | null | 0 |
| 02 | 07-JAN-19 | null | null | null | 0 |
| 03 | 14-JAN-19 | null | null | null | 0 |
| 04 | 21-JAN-19 | null | null | null | 0 |
| 05 | 28-JAN-19 | null | null | null | 0 |
| 06 | 04-FEB-19 | null | null | null | 0 |
| 07 | 11-FEB-19 | null | null | null | 0 |
| 08 | 18-FEB-19 | null | null | null | 0 |
| 09 | 25-FEB-19 | null | null | null | 0 |
| 10 | 04-MAR-19 | null | null | null | 0 |
| 11 | 11-MAR-19 | null | null | null | 0 |
| 12 | 18-MAR-19 | null | null | null | 0 |
| 13 | 25-MAR-19 | null | null | null | 0 |
| 14 | 01-APR-19 | null | null | null | 0 |
| 15 | 08-APR-19 | null | null | null | 0 |
| 16 | 15-APR-19 | null | null | null | 0 |
| 17 | 22-APR-19 | null | null | null | 0 |
| 18 | 29-APR-19 | null | null | null | 0 |
| 19 | 06-MAY-19 | null | null | null | 0 |
| 20 | 13-MAY-19 | null | null | null | 0 |
| 21 | 20-MAY-19 | null | null | null | 0 |
| 22 | 27-MAY-19 | 28-MAY-19 | 29-MAY-19 | 1 | 1 |
| 22 | 27-MAY-19 | 29-MAY-19 | 01-JUN-19 | 0 | 0 |
| 23 | 03-JUN-19 | null | null | null | 0 |
| 24 | 10-JUN-19 | 11-JUN-19 | 12-JUN-19 | 1 | 1 |
| 24 | 10-JUN-19 | 12-JUN-19 | 12-JUN-19 | 0 | 0 |
| 25 | 17-JUN-19 | null | null | null | 0 |
| 26 | 24-JUN-19 | null | null | null | 0 |
| 27 | 01-JUL-19 | null | null | null | 0 |
| 28 | 08-JUL-19 | null | null | null | 0 |
| 29 | 15-JUL-19 | null | null | null | 0 |
| 30 | 22-JUL-19 | null | null | null | 0 |
| 31 | 29-JUL-19 | null | null | null | 0 |
| 32 | 05-AUG-19 | null | null | null | 0 |
| 33 | 12-AUG-19 | null | null | null | 0 |
| 34 | 19-AUG-19 | null | null | null | 0 |
| 35 | 26-AUG-19 | null | null | null | 0 |
| 36 | 02-SEP-19 | null | null | null | 0 |
| 37 | 09-SEP-19 | null | null | null | 0 |
| 38 | 16-SEP-19 | null | null | null | 0 |
| 39 | 23-SEP-19 | null | null | null | 0 |
| 40 | 30-SEP-19 | null | null | null | 0 |
| 41 | 07-OCT-19 | null | null | null | 0 |
| 42 | 14-OCT-19 | null | null | null | 0 |
| 43 | 21-OCT-19 | null | null | null | 0 |
| 44 | 28-OCT-19 | null | null | null | 0 |
| 45 | 04-NOV-19 | null | null | null | 0 |
| 46 | 11-NOV-19 | null | null | null | 0 |
| 47 | 18-NOV-19 | null | null | null | 0 |
| 48 | 25-NOV-19 | null | null | null | 0 |
| 49 | 02-DEC-19 | null | null | null | 0 |
| 50 | 09-DEC-19 | null | null | null | 0 |
| 51 | 16-DEC-19 | null | null | null | 0 |
| 52 | 23-DEC-19 | null | null | null | 0 |