Question: what is the difference between correlated subquery and subquery?
Answer: A subquery is a select statement that is embedded in a clause of another select statement. ... A Correlated subquery is a subquery that is evaluated once for each row processed by the outer query or main query.