Which three statements are true about multiple-row subqueries?
A.
They can contain a subquery within a subquery.
B.
They can return multiple columns as well as rows.
C.
They cannot contain a subquery within a subquery.
D.
They can return only one column but multiple rows.
E.
They can contain group functions and GROUP BY and HAVING clauses.
F.
They can contain group functions and the GROUP BY clause, but not the HAVING clause.