https://itinterviewguide.com/correlated-subquery/
How Can the Correlated Subquery be Efficient? – It Interview Guide
A SQL correlated subquery is just a query that carries over values from the outer query. This means that there is a WHERE statement using…
correlated subqueryefficientinterviewguide