Which query would find the total number of orders placed for each product, showing only products with a total quantity above 100?
Orders: (OrderID, ProductID, Quantity)

Question

Which query would find the total number of orders placed for each product, showing only products with a total quantity above 100? 
 Orders: (OrderID, ProductID, Quantity)

Accepted Answer

SELECT ProductID, SUM(Quantity)  FROM Orders  GROUP BY ProductID  HAVING SUM(Quantity) > 100;

Answer

SELECT ProductID, SUM(Quantity)  FROM Orders  GROUP BY ProductID;

Answer

SELECT ProductID, SUM(Quantity)  FROM Orders  WHERE SUM(Quantity) > 100  GROUP BY ProductID;

Answer

SELECT ProductID, COUNT(Quantity)  FROM Orders  GROUP BY ProductID  HAVING COUNT(Quantity) > 100;

Crowdly

Which query would find the total number of orders placed for each product, showi...

Want instant access to all verified answers on eclass.yorku.ca?