By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
14 rows affected
| WeekOfYear | Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|---|
| 36 | 2020-08-30->0 | 2020-08-31->0 | 2020-09-01->1 | 2020-09-02->1 | 2020-09-03->1 | 2020-09-04->1 | 2020-09-05->0 |
| 37 | 2020-09-06->0 | 2020-09-07->9 | 2020-09-08->9 | 2020-09-09->9 | 2020-09-10->9 | 2020-09-11->9 | 2020-09-12->0 |
Warning: Null value is eliminated by an aggregate or other SET operation.