What is a correlated subquery vs a scalar subquery?

Question

Advanced SQL Developer — Medium

What is a correlated subquery vs a scalar subquery?

Accepted Answer

A scalar subquery returns a single row and column, executing independently once. In contrast, a correlated subquery re-executes for each row in the outer query, returning one row per outer row.