'Order' table:

We want to find the total sum (total order) of each customer. Which of the below statement should we use?

Question

'Order' table: 
  
 We want to find the total sum (total order) of each customer. Which of the below statement should we use?

Answer

SELECT Customer, SUM(OrderPrice) FROM Order GROUP BY Customer

Answer

SELECT Customer, SUM(OrderPrice) FROM Orders GROUP BY Orders

Answer

SELECT Customer, SUM(OrderPrice) FROM Orders GROUP BY OrderPrice

Answer

SELECT Customer, SUM(OrderPrice) FROM Orders GROUP BY Customer

O_Id	OrderDate	OrderPrice	Customer
1	2009/12/12	1000	Harry
2	2008/03/23	1600	Nancy
3	2008/09/02	700	Harry
4	2008/09/03	300	Harry
5	2008/08/30	2000	Jensen
6	2008/03/04	100	Nancy

Crowdly