By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
10 rows affected
STORE | ITEM | PROMO_FLG | NUM_STORES | NUM_PROMO_1 |
---|---|---|---|---|
1 | 1 | 0 | 10 | 4 |
2 | 1 | 1 | 10 | 4 |
3 | 1 | 0 | 10 | 4 |
4 | 1 | 0 | 10 | 4 |
5 | 1 | 1 | 10 | 4 |
6 | 1 | 1 | 10 | 4 |
7 | 1 | 1 | 10 | 4 |
8 | 1 | 0 | 10 | 4 |
9 | 1 | 0 | 10 | 4 |
10 | 1 | 0 | 10 | 4 |
ITEM | STORE | PROMO_FLG | NUM_STORES | NUM_STORES_PROMO |
---|---|---|---|---|
1 | 1 | 0 | 10 | 4 |
1 | 2 | 1 | 10 | 4 |
1 | 3 | 0 | 10 | 4 |
1 | 4 | 0 | 10 | 4 |
1 | 5 | 1 | 10 | 4 |
1 | 6 | 1 | 10 | 4 |
1 | 7 | 1 | 10 | 4 |
1 | 8 | 0 | 10 | 4 |
1 | 9 | 0 | 10 | 4 |
1 | 10 | 0 | 10 | 4 |