Þ D. THIS IS A CORRELATED SUBQUERY, WHICH MUST BE RUN FOR EVERY ROW...

4. þ D. This is a correlated subquery, which must be run for every row in the table.

ý A, B, and C. The result of the inner query is dependent on a value from

the outer query; it must therefore be run once for every row.