Hugo Kornelis (7/28/2014)
LOL!!I simply cannot believe the amount of discussion over what can of course only be a simple mistake by the question author.
The very definition of "correlated" is that the inner query references a column from the outer query and hence has to be (logically) re-evaluated for every row (or at least every distinct referenced value) from the outer query.
I think there is so much discussion because so many of us picked "D" thinking (with great confidence) that we were correct. I'm still sticking to my guns on D being more correct than C but it doesn't really matter. It's just points!
Ken