Subqueries

Queries within queries.

Example

-- Find users who have placed an order
SELECT name FROM users WHERE id IN (SELECT user_id FROM orders);