Summer Lewis

Use aggregate functions in query

Task 4 REVISED

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

select sum(ItemQty) from Orders;
SELECT CustomerID, COUNT(*) AS NumberOfOrders FROM Orders GROUP BY CustomerID ORDER BY CustomerID;
SELECT CustomerID, MAX(ItemQty) AS HighestQtyOrdered FROM Orders GROUP BY CustomerID ORDER BYCustomerID;
select min(DateOrdered) from Orders;