Subquery challenge

Write a complex condition with a correlated subquery.

In this challenge you will find products above average with a correlated subquery.

SELECT name FROM products p
WHERE price > (SELECT AVG(price) FROM products WHERE category = p.category);

This query products above their category average.

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

Exercise Subquery challenge

Find products above their category average with a correlated subquery.

Show example solution

SELECT name FROM products p
WHERE price > (SELECT AVG(price) FROM products WHERE category = p.category);

Add p.category

WHERE category = ____

Show answer

WHERE category = p.category