Описание тега correlated-subquery
Correlated sub-query is a sub-query (a query nested inside another query) that uses values from the outer query.
In a SQL database query, a correlated sub-query (also known as a synchronized subquery) is a sub-query (a query nested inside another query) that uses values from the outer query.
The sub-query is evaluated once for each row processed by the outer query.