What is the difference between a correlated subquery and a non-correlated subquery?

Question

SQL Data Analyst — Medium

What is the difference between a correlated subquery and a non-correlated subquery?

Accepted Answer

A correlated subquery is different from a non-correlated subquery because it references a column from the outer query and re-executes for each outer row, while a non-correlated subquery runs once independently.