מה אומרת השגיאה הבאה:

The ORDER BY clause is invalid in views, inline functions, derived tables, and subqueries, unless TOP is also specified.