57.
You can't have a order by clause in a Sub-Query ?
View Description
ORDER BY Clause (Transact-SQL)
Specifies the sort order used on columns returned in a SELECT statement. The ORDER BY clause is not valid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.