Subqueries

A query used as a value, a table, or a predicate. Correlated vs uncorrelated is the performance fork.

Level: intermediate