A subquery is allowed in which parts of a SQL SELECT statement?

True or false: A correlated subquery references a table in the SELECT clause.

Which set operator will not remove duplicate rows from the result of a compound query?

What characteristics of the columns in a compound query using INTERSECT must match?

How are NULL values handled using set operators in a compound UNION query?

Why are ROLLUP and CUBE the preferred methods for generating subtotals and grand totals for an aggregate query?

Which operators can be used to compare a column to a single-row subquery?

A compound query that needs to find only the rows that are the same between the two queries should use the __________ set operator.

True or false: The IN operator cannot be used with a single-row subquery.

Put the set operators UNION, UNION ALL, INTERSECT, and MINUS in order of precedence.

What can be used to change the precedence of a pair of queries in a compound query with more than two queries?