This website uses cookies to ensure you get the best experience.
Learn more.
Sales has Region and Amount. Which queries return only regions whose total Amount exceeds 100000? Select 2 answers.
Published
- SELECT Region, SUM(Amount) FROM Sales WHERE SUM(Amount) > 100000 GROUP BY Region
- SELECT Region, SUM(Amount) AS Total FROM Sales GROUP BY Region HAVING SUM(Amount) > 100000
- SELECT Region, SUM(Amount) FROM Sales WHERE Amount > 100000 GROUP BY Region
- SELECT Region, Total FROM (SELECT Region, SUM(Amount) AS Total FROM Sales GROUP BY Region) s WHERE Total > 100000
Comments — 0
Sign in to comment