Subquery Rules
The SELECT list of an inner subquery introduced with a comparator or IN can only have 1 expression or column name.
Subqueries introduced with EXISTS almost always have a select list of *.
Subqueries cannot manipulate their results. Cannot use ORDER BY or INTO.