Skip to main content
Journey Uncommon Logo
JourneyUncommon
easySQLaggregate functionsSingle-choice MCQ

You want the total revenue per product, but only for products whose total revenue exceeds 1000. Which clause filters on the aggregated SUM?

SELECT product, SUM(revenue) FROM sales GROUP BY product ______ SUM(revenue) > 1000;