Who scored above the average? To answer, you first need the average. A subquery is a query in parentheses inside another query, and its answer feeds straight into the outer one.