Can't have aggregate function in ORDER BY clause (Item).
Error 3097
You can't use an aggregate function in the ORDER BY Clause (SQL)15DW835 of an SQL statement29F05E5.
See Also
SQL Aggregate FunctionsM7QTSY