Correlated subquery

Also written: correlated subqueries

A subquery that refers to a column of the outer query, so it runs again for every outer row. For example, it counts each café's own orders.