A query can hold another query inside it

Put a query inside parentheses and its answer can be used inside a bigger query. The database works out the inner query first, then uses that answer in the outer one. Here the inner query works out the average number of pages, and the outer query keeps the books with more pages than that average.

SELECT title
FROM books
WHERE pages > (
  SELECT AVG(pages)
  FROM books
);