Which two statements are true regarding subqueries? (Choose two.)
A.
The ORDER BY clause can be used in the subquery.
B.
Logical operators, such as AND, OR and NOT, cannot be used in the WHERE clause of
a subquery.
C.
A subquery can be placed in a WHERE clause, GROUP BY clause, or a HAVING clause.
D.
If the subquery returns NULL, the main query may still return result rows.
E.
A subquery can be used in the FROM clause of a SELECT statement.
answer: ACDE