By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
12 rows affected
| store | date | is_open | grp |
|---|---|---|---|
| Bay | 2022-01-01 | true | 1 |
| Bay | 2022-02-01 | true | 1 |
| Bay | 2022-03-01 | true | 1 |
| Bay | 2022-04-01 | false | 2 |
| Bay | 2022-05-01 | false | 2 |
| Bay | 2022-06-01 | false | 2 |
| Bay | 2022-07-01 | true | 3 |
| Bay | 2022-08-01 | true | 3 |
| Bay | 2022-09-01 | true | 3 |
| Walmart | 2022-07-01 | true | 1 |
| Walmart | 2022-08-01 | false | 2 |
| Walmart | 2022-09-01 | true | 3 |