A regular subquery and a correlated subquery.

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