By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
8 rows affected
| prod_num | cluster |
|---|---|
| 0 | Q1 |
| 0 | Q2 |
| 1 | Q3 |
| 1 | Q4 |
| 0 | Q5 |
| 1 | Q6 |
Warning: Null value is eliminated by an aggregate or other SET operation.
8 rows affected
| prod_num | cluster |
|---|---|
| 0 | Q1 |
| 0 | Q2 |
| 1 | Q3 |
| 1 | Q4 |
| 0 | Q5 |
| 1 | Q6 |
Warning: Null value is eliminated by an aggregate or other SET operation.