Examine the Sale and Cash Receipt Relational Tables and the Corresponding

Multiple Choice

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;