ORDER BY phrases cannot be used in subqueries (although ORDER BY phrases can still be used in outer queries that contain subqueries). Subqueries in SELECT or WHERE clauses that return more than one ...