Examine the Sale and Cash Receipt relational tables and the corresponding query solution below. Which of the following SQL query statements applied to those tables will result in the depicted solution?
A) SELECT CustomerID, Sum(Amount)FROM Sale;
B) SELECT CustomerID, Sum(Amount)FROM Sale GROUP BY CustomerID;
C) SELECT CustomerID, AmountFROM Sale;
D) SELECT CustomerID, Sum(Amount)FROM SaleWHERE CustomerID unique;
E) SELECT CustomerID, AmountFROM Sale GROUP BY Amount;

Question

Quizplus · Accepted Answer

The query in option B groups the sales by CustomerID and calculates the sum of the Amount for each customer, which matches the described solution.

Examine the Sale and Cash Receipt Relational Tables and the Corresponding