By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| LOCATION | PRODUCTS | Qty A | Qty B |
|---|---|---|---|
| WH 1 | PRODUCT NO. 1 | 10 | 10 |
| WH 2 | PRODUCT NO. 1 | 0 | 14 |
| WH 1 | PRODUCT NO. 2 | 100 | 100 |
| WH 1 | PRODUCT NO. 333 | 5 | 5 |
| WH 1 | PRODUCT NO. XXX | 0 | 77 |
| WH 1 | PRODUCT NO. YYY | 0 | 555 |
| WH 2 | PRODUCT NO. YYY | 22 | 45 |