By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| store_id | industry | pct_my_store_only | pct_both | pct_other_stores_only |
|---|---|---|---|---|
| 200 | 1000 | 0.5000 | 0.5000 | 0.0000 |
| 300 | 2000 | 0.5000 | 0.5000 | 0.0000 |
| 400 | 1000 | 0.0000 | 1.0000 | 0.0000 |