Sku         WhseId      Qty
============================
ABC-123     1           6
ABC-123     2           3
ABC-123     3           2
XYZ-789     1           0
XYZ-789     2           1
XYZ-789     3           3
DEF-456     1           0
DEF-456     2           0
DEF-456     3           3

SELECT Sku, WhseId, Qty
FROM PRODUCTS
WHERE (WhseId = 1 AND Qty < 1)
AND (WhseId = 2 AND Qty > 0
AND (WhseId = 3 AND Qty > 0)
GROUP BY Sku, WhseId, Qty

Sku         WhseId      Qty
============================
XYZ-789     1           0
XYZ-789     2           1
XYZ-789     3           3