Sales has Region and Amount. Which queries return only regions whose total Amount exceeds 100000? Select 2 answers.

Published
  1. SELECT Region, SUM(Amount) FROM Sales WHERE SUM(Amount) > 100000 GROUP BY Region
  2. SELECT Region, SUM(Amount) AS Total FROM Sales GROUP BY Region HAVING SUM(Amount) > 100000
  3. SELECT Region, SUM(Amount) FROM Sales WHERE Amount > 100000 GROUP BY Region
  4. SELECT Region, Total FROM (SELECT Region, SUM(Amount) AS Total FROM Sales GROUP BY Region) s WHERE Total > 100000

Comments — 0