Question

Orders(OrderID, CustomerID, Amount) has multiple orders per customer. Which query returns customers whose total order amount exceeds 100000?

SUM is evaluated per group, so its filtering condition belongs in HAVING after GROUP BY. WHERE cannot directly filter on the grouped SUM.

A SELECT CustomerID FROM Orders WHERE SUM(Amount) >100000 GROUP BY CustomerID;

B SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING SUM(Amount) >100000;

C SELECT CustomerID FROM Orders HAVING Amount >100000;

D SELECT DISTINCT CustomerID FROM Orders WHERE Amount >100000;

E SELECT CustomerID,SUM(Amount) FROM Orders WHERE SUM(Amount) >100000;

More SQL Questions

🎓

Think You're Ready for RBI Grade B?