>What does it mean to be a 'correlated query'.

The correlated subquery runs for every record in the outer query and uses column values from outer query record in its where clause.

< snip >