Question

Given a table Orders(OrderID, CustomerID, Amount), which SQL statement correctly returns the CustomerID of every customer who has placed more than 3 orders with a combined order amount exceeding 5000?

Q: Answer-Given a table Orders(OrderID, CustomerID, Amount), which SQL statement correctly returns the Custome...

WHERE filters individual rows before any grouping occurs, so it cannot reference aggregate functions like COUNT or SUM attempting to use WHERE with aggregates as in options A, C, and E is a syntax error. HAVING is specifically designed to filter groups after aggregation has been performed, and it must appear after the GROUP BY clause, not before it ruling out option D. Option B correctly groups by CustomerID first and then filters those groups using HAVING with both aggregate conditions.

A SELECT CustomerID FROM Orders WHERE COUNT(*) > 3 AND SUM(Amount) > 5000 GROUP BY CustomerID;

B SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) > 3 AND SUM(Amount) > 5000;

C SELECT CustomerID FROM Orders GROUP BY CustomerID WHERE COUNT(*) > 3 AND SUM(Amount) > 5000;

D SELECT CustomerID FROM Orders HAVING COUNT(*) > 3 AND SUM(Amount) > 5000 GROUP BY CustomerID;

E SELECT CustomerID, COUNT(*), SUM(Amount) FROM Orders WHERE CustomerID GROUP BY HAVING COUNT(*) > 3 AND SUM(Amount) > 5000;

Practice Next

More IT DBMS Questions

Which query correctly finds department IDs where the average salary exceeds the overall average salary across all employees?
You have a Python list of fruits and want to extract a specific sub-list using slicing. Complete the missing part of the code to obtain the sub-list `['b...
Which SQL keyword is used to combine the result sets of two or more SELECT statements, automatically removing duplicate rows from the combined result?
T1 updates a row but has not committed; T2 reads that updated value; T1 then rolls back. What anomaly did T2 experience?
Which of the following ACID properties ensures that either all operations within a transaction are completed successfully, or none are?
Which of the following is not part of the process control block (PCB)?
In PL/SQL, a `CURSOR` is used to:
Which of the following is an example of a NoSQL database?
Which transaction isolation level permits non-repeatable reads and phantom reads while still guaranteeing that dirty reads never occur?
Which key, selected from among the candidate keys of a table, is used to uniquely identify each record and is automatically enforced by the DBMS to disallo...

Hey! Ask a query

🎓

Think You're Ready for RBI Grade B?

RBI Grade B 2026 Phase 1 Memory Based Paper

200 Questions with Detailed Solutions
Section-wise Coverage (GA, English, Quant & Reasoning)

Download Now 100% Free PDF

Given a table Orders(OrderID, CustomerID, Amount), which SQL statement correctly returns the CustomerID of every customer who has placed more than 3 orders with a combined order amount exceeding 5000?

Detailed Solution

More IT DBMS Questions

Hey! Ask a query

Please Register/Login

RBI Grade B 2026 Phase 1 Memory Based Paper