This website uses cookies to ensure you get the best experience.
Learn more.
Sales has Region and Amount. You need one row per Region where total Amount exceeds 5,000. Which clause applies that aggregate threshold?
Published
- ORDER BY Amount > 5000 alone
- WHERE SUM(Amount) > 5000 before grouping
- HAVING SUM(Amount) > 5000 after GROUP BY Region
- DISTINCT Region alone
Comments — 0
Sign in to comment