Which three statements are true reading subquenes?
A. A Main query can have many subqueries.
B. A subquery can have more than one main query.
C. The subquery and main query must retrieve date from the same table.
D. The subquery and main query can retrieve data from different tables.
E. Only one column or expression can be compared between the subquery and main query.
F. Multiple columns or expressions can be compared between the subquery and main query.