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