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

A relation R(P, Q, R, S) has functional dependencies PQ -> R, R -> S, and S -> P. How many candidate keys does this relation have?
Which concurrency anomaly is specific to phantom reads?
Consider the schedule S: r1(A), r2(A), w1(A), w2(A) of transactions T1 and T2. Which statement about S is correct?
Consider the schedule S: R1(A), R2(A), W1(A), W2(A), where Ri and Wi denote read and write by transaction Ti. Which statement about S is correct?
A table contains 1,000,000 records, and a B+ tree index built on it has a fan-out (branching order) of exactly 100 at each internal node. What is the appro...
In a relational database, which relationship allows multiple records in one table to be associated with multiple records in another table?
A relation R(A,B,C,D) has functional dependencies A→B and B→C. Which statement follows?
In DBMS, which scheduling method ensures serializability of transactions?
In database normalization theory, which anomaly specifically refers to the unintended loss of information when a record is removed, because that record hap...
Which ACID property of a database transaction ensures that a transaction is executed either completely or not at all, with no partial updates left in the d...

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