1 point
Q3. Look the following
Table:ORDERS table. We want
to find the total sum (total
order) of each customer.
Which of the below statement
should we use:
O_ld
Order Price
Customer
1
1000
2
1600
Order Date
2009/12/12
2008/03/23
2008/09/02
2008/09/03
2008/08/30
2008/03/04
Harry
Nancy
Harry
700
300
Harry
5
2000
Jensen
6
100
Nancy
O
SELECT Customer, SUM(Order Price)
FROM Orders GROUP BY Customer;
O
SELECT Customer,SUM(OrderPrice)
FROM Orders GROUP BY Orders;
O
SELECT Customer,SUM(OrderPrice)
FROM Orders ORDER BY Customer;
O
SELECT Customer, SUM(Order Price)
FROM Orders GROUP BY OrderPrice;
Answers
Answered by
0
Answer:
Sorry I can't get to your question
Similar questions