SELECT
  CASE
    WHEN EXISTS(SELECT 1 FROM Product WHERE ProdID = p.ProdID AND HasImage = 1)
    THEN
      1
    ELSE
      0
    END
  AS HasImage,
  (SELECT Sum(StockBalance) FROM Product WHERE ProdID = p.ProdID) AS StockBalance,
  CASE
    WHEN EXISTS(SELECT 1 FROM Product WHERE ProdID = p.ProdID AND Price IS NULL)
    AND EXISTS(SELECT 1 FROM Product WHERE ProdID = p.ProdID AND DiscountPrice IS NULL)
    THEN
      0
    ELSE
      1
    END
    AS HasPrice
FROM ProductSuper p