Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLcorrelated subqueriesSingle-choice MCQ

A correlated subquery in a WHERE clause computes a per-row aggregate. What does this query return?

SELECT o1.* FROM orders o1 WHERE o1.amount > ( SELECT AVG(o2.amount) FROM orders o2 WHERE o2.customer_id = o1.customer_id );