Question: what is the difference between a correlated subquery and a non correlated subquery?
Answer: A noncorrelated (simple) subquery obtains its results independently of its containing (outer) statement. A correlated subquery requires values from its outer query in order to execute.