Explain correlated subqueries and give an example

Question Explain

This tests understanding of subqueries dependent on outer rows. It evaluates advanced query logic skills.