"In Transact-SQL, a subquery can appear almost anywhere an expression can be used, if it returns a single value."