ADP interview question

Explain how a correlated subquery works (SQL)