I figured what the question was going for but I agree the correct answer should have been D. I saw the problem as the specific wording of RESULT. The whole issue with a correlated sub-query is the dependency of the inner query on a candidate row value set (not the entire result set) in order to process and return its result (typically a single value) to the outer query.