MILEEZRA

SELECT P.PRODUCTVENDOR, SUM(OD.QUANTITYORDERED)
FROM PRODUCTS P JOIN ORDERDETAILS OD ON P.PRODUCTCODE = OD.PRODUCTCODE
WHERE P.PRODUCTVENDOR LIKE '%Unimax Art Galleries%' OR
	  P.PRODUCTVENDOR LIKE '%Exoto Designs%' OR
      P.PRODUCTVENDOR LIKE '%Gearbox Collectibles%' OR
      P.PRODUCTVENDOR LIKE '%Red Start Diecast%'
GROUP BY P.PRODUCTVENDOR;