Summer Lewis

Use HAVING clause with GROUP BY

Task 5 REVISED

  • December 16, 2016 at 11:50 AM
  • Visible to public
Link to revised queries:
https://drive.google.com/open?id=0B5hBlRd1P7vEdk9zdzZRNVBpaDQ

SELECT CustomerID, COUNT(*) AS NumberOfOrders FROM Orders GROUP BYCustomerID HAVING COUNT(*) > 1;
SELECT ItemNumber, ItemDescription, SUM(NumberInStock) ASNumberOfProductsInStock FROM Products GROUP BY ItemNumber HAVINGSUM(NumberInStock) > 10;