ORDER BY and GROUP BY

You can use an ORDER BY clause to order the results of a GROUP BY in a particular way.

Example

The following query finds the average price of each product and orders the results by average price:

SELECT Name, AVG( UnitPrice )
   FROM Products
   GROUP BY Name
   ORDER BY AVG( UnitPrice );
Name AVG(Products.UnitPrice)
Visor 7
Baseball Cap 9.5
Tee Shirt 12.333333333
Shorts 15
... ...