Sales has Region and Amount. You need one row per Region where total Amount exceeds 5,000. Which clause applies that aggregate threshold?

Published
  1. ORDER BY Amount > 5000 alone
  2. WHERE SUM(Amount) > 5000 before grouping
  3. HAVING SUM(Amount) > 5000 after GROUP BY Region
  4. DISTINCT Region alone

Comments — 0