Did you know that SQL has a for loop? That’s all a “correlated subquery” is — just a for loop over a query I use a correlated subquery when I want to “execute a query” for each row in a base table ...