ORDER BY with GROUP BY

ORDER BY can be performed on any expression in the GROUP BY expression-list or any column in the result set.