What is a subquery?

Run a query inside another query.

A subquery is a query inside another query. It is wrapped in parentheses.

SELECT name FROM products
WHERE price > (SELECT AVG(price) FROM products);

This query returns products above the average.

name is selected from products. WHERE keeps only the rows where price > (SELECT AVG(price) FROM products) holds.

What is a subquery? — details

The subquery runs first and feeds its result to the outer query. It enables nested queries.

For example, WHERE price > (SELECT AVG(price) FROM products) computes the average first, then returns products above it.

Find products priced above average using a subquery.

Show example solution

SELECT name FROM products
WHERE price > (SELECT AVG(price) FROM products);

Add parentheses

SELECT name FROM products
WHERE price > ____SELECT AVG(price) FROM products);

Show answer

SELECT name FROM products
WHERE price > (SELECT AVG(price) FROM products);