Question: what is the difference between correlated subqueries and uncorrelated subqueries?
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.