A subquery in an sql select statement

By John

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.

Answer: Option C