Subquery And Correlated Subquery Differences

Respond to the following in a minimum of 175 words:

• Discuss the differences between a regular subquery and a correlated subquery.
• Provide an example of one or both subqueries.