Question: what is the difference between correlated and uncorrelated subquery?
Answer: A non-correlated subquery is executed only once and its result can be swapped back for a query, on the other hand, a correlated subquery executed multiple times, precisely once for each row returned by the outer query.