Subquery
A query nested inside another query.
Subqueries can appear in SELECT, FROM, or WHERE clauses. A correlated subquery references the outer query's rows. CTEs are often preferred over subqueries for readability in complex analytical queries.
Example
SELECT * FROM equity_prices WHERE close > (SELECT AVG(close) FROM equity_prices);