A retail company maintains two tables: Customers(CustID, CustName) and Orders(OrderID, CustID, OrderAmount). They want to view the total spending of each customer. Which SQL statement best achieves this?

Question

Computer Science · Database Management Systems

Verified Solution4 OptionsUpdated: October 2026👁️1 View

Share:

Correct answer

SELECT CustName, SUM(OrderAmount) FROM Customers JOIN Orders ON Customers.CustID = Orders.CustID GROUP BY CustName;

Save this question and verified answer as a clean study sheet with live clickable link.

👥

Challenge your peer aspirants on WhatsApp or Telegram to solve this question!

Online Test Series

Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.

Chapter Practice

Want more practice questions on Database Management Systems?

Solve complete topic-wise tests with detailed solutions on GkGet.

Recommended practice questions in Computer Science · Database Management Systems

Which movement aimed to promote Khadi, a hand-spun and handwoven cloth native to India?

Who were prominent leaders associated with the initial phase of the Telangana Rebellion (1946-1951) against the Nizam's rule and feudal landlords?

What was the immediate trigger for the Revolt of 1857?

Answer 1

SELECT * FROM Customers, Orders WHERE OrderAmount > 0;

Answer 2

SELECT CustName, OrderAmount FROM Customers NATURAL JOIN Orders;

Answer 3

SELECT CustName, SUM(OrderAmount) FROM Customers JOIN Orders ON Customers.CustID = Orders.CustID GROUP BY CustName;

Answer 4

SELECT CustName, SUM(OrderAmount) FROM Orders;

Related Practice Questions