#$16$ What is the effect of including a subquery in the WHERE clause?

SELECT ONE OF THE FOLLOWING $(1$ PT$)$

A$.$ The results of the subquery are used to determine which rows end up in the results of the outer query

B$.$ A subquery cannot be included in the WHERE clause

C$.$ The results of the subquery filter groups, similar to the HAVING clause

D$.$ The columns returned by the subquery may be used in the SELECT clause of the outer query