Which three statements are true regarding sub queries? (Choose three.)
A.
Sub queries can contain ORDER BY but not the GROUP BY clause
B.
Multiple columns or expressions can be compared between the main query and sub
query
C.
Only one column or expression can be compared between the main query and subqeury
D.
Sub queries can contain GROUP BY and ORDER BY clauses
E.
Main query and sub query can get data from different tables
F.
Main query and sub query must get data from the same tables
B-D-E