complete SELECT statements embedded inside other SELECT statements. A subquery computes one result, and the outer query uses that result as if it were a constant, a list, or an entire table. Once you internalize this pattern, the complexity ceiling of what you can express in a single SQL statement r