By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| store_id | pct_sales_a | pct_sales_b | pct_sales_ab |
|---|---|---|---|
| 1 | 1.0000 | 0.0000 | 0.0000 |
| 2 | 0.0000 | 0.5000 | 0.5000 |
| store_id | pct_sales_a | pct_sales_b | pct_sales_ab |
|---|---|---|---|
| 1 | 1.0000 | 0.0000 | 0.0000 |
| 2 | 0.0000 | 0.5000 | 0.5000 |