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 |