Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
You can use an ORDER BY clause to order the results of a GROUP BY in a particular way.
The following query finds the average price of each product and orders the results by average price:
SELECT Name, AVG( UnitPrice )
GROUP BY Name
ORDER BY AVG( UnitPrice );