PostgreSQL subqueries allow one SQL query to run inside another, making it possible to solve filtering, aggregation, ...