What is a sub-select statement?
A.
a select statement that selects a subset of fields in a table
B.
a select statement that returns a subset of the data in a table
C.
a select statement that appears within another select statement
D.
a select statement that returns a subset of the constraints on a field