Improved: Semantic error notified when ORDER BY clause in scalar subquery