Which three statements about subqueries are true?()
A、A. A single row subquery can retrieve only one column and one row.
B、B. A single row subquery can retrieve only one row but many columns.
C、C. A multiple row subquery can retrieve multiple rows and multiple columns.
D、D. A multiple row subquery can be compared by using the “>” operator.
E、E. A single row subquery can use the IN operator.
F、F. A multiple row subquery can use the “=” operator.