Summer Lewis

Use HAVING clause with GROUP BY

Task 5

  • November 3, 2016 at 10:15 AM
  • Visible to public
I have all of my queries listed here, grouped by task:
https://drive.google.com/open?id=0B5hBlRd1P7vEbXF6azltbXBHU0E
  1. select OrderNumber, ItemQty, DateOrdered from Orders group by DateOrdered having ItemQty > 1;
  2. select ItemNumber, NumberInStock, ItemLocation from Products group by ItemNumber having NumberInStock > 1 order by ItemLocation;