Which three statements are true about multiple-row sub queries? (Choose three.)
A.
They can contain a subquery within a sub query.
B.
They can return multiple columns as well as rows.
C.
They cannot contain a sub query within a sub query.
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.