The differences between a regular subquery and a correlated subquery.

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.