A subquery in an SQL SELECT statement:

• A. can only be used with two tables.
• B. can always be duplicated by a join.
• C. has a distinct form that cannot be duplicated by a join.
• D. cannot have its results sorted using ORDER BY.