Listing 6.16[em]The HAVING Clause Filters the Display of the Selected Group Records
SELECT SL.SalesID, Min(SL.Quantity * RT.Retail) AS Minsls,  _
     Max(SL.Quantity * RT.Retail) AS Maxsls,  _
     Avg(SL.Quantity * RT.Retail) AS Avgsls,  _
     Sum(SL.Quantity * RT.Retail) AS Totsls,  _
     Sum(SL.Quantity) AS Totvol  _
     FROM Sales AS SL, [Retail Items] AS RT  _
     SL INNER JOIN RT ON SL.[Item Code]=RT.[Item Code]  _
     GROUP BY SL.SalesID  _
     HAVING Sum(SL.Quantity * RT.Retail) > 3000