现有汽车销售表c_orders,包含字段:c_id(订单编号),c_date(订单日期),c_price(订单金额),c_customer(客户姓名),可以查找每个客户总金额的是()。
A.SELECT c_customer,SUM(c_price)FROM c_orders GROUP BY c_customer
B.SELECT c_customer,SUM(c_price)FROM c_orders GROUP BY c_id
C.SELECT c_customer,COUNT(c_price)FROM c_orders GROUP BY c_customer
D.SELECT c_customer,SUM(c_price)FROM c_orders Order BY c_customer