What is true regarding subqueries?
A.
The inner query must always return a value or the outer query will give an error.
B.
The inner query returns a value to the outer query.
C.
The inner query always sorts the results of the outer query.
D.
The outer query must return a value to the inner query.
E.
The outer query always sorts the results of the inner query.
Explanation:
The inner query returns a value to the outer query. If the inner query does not return a value, the
outer query does not return a result