Subquery

A subquery is a query nested inside another query. The inner query runs first, and its result is used by the outer query.