10. Aggregate Functions

Activity 10.01: Working with Aggregates

1. Write the following code in a new query tab:

   SELECT OI.OrderID, P.ProductName,
       SUM(OI.Quantity) AS
         'COUNT OF EACH SEPARATE PRODUCT IN THE ORDER',
             SUM(SUM(OI.Quantity)) OVER(PARTITION BY OI.OrderID)
             AS 'TOTAL COUNT OF PRODUCTS IN THE ORDER',
             MAX(MAX(OI.Quantity)) OVER(PARTITION BY OI.OrderID)
             AS 'COUNT OF THE PRODUCT WITH THE HIGHEST 
             ORDER COUNT IN THE ORDER'
   FROM      OrderItems OI INNER JOIN
             Products P ON OI.ProductID = P.ProductID
   GROUP BY  OI.OrderID, P.ProductName
   ORDER BY  OI.OrderID;

2. Execute the query, it should...