SQL 45 🛢️ Correlated Subqueries
A subquery that references a column from the outer query is correlated. This single characteristic changes everything about how the subquery behaves. An uncorrelated subquery runs once and produces a result that the outer query uses. A correlated subquery runs once for every row the outer query processes, because its result depends on the specific…