Regions above a revenue threshold

SQLBeginnermultiple choiceSample content

Which query returns regions whose total revenue exceeds 500,000?

SELECT region, SUM(revenue) FROM sales WHERE SUM(revenue) > 500000 GROUP BY region;SELECT region, SUM(revenue) FROM sales GROUP BY region HAVING SUM(revenue) > 500000;SELECT region, revenue FROM sales WHERE revenue > 500000;SELECT region FROM sales HAVING revenue > 500000;