多选题

有如下示例数据： 订单明细表：test_order_item id ord...

Question

有如下示例数据：
订单明细表：test_order_item

id order_id goods_id price
1 11701245001 1001 10
2 11701245001 1002 20
3 11701245002 1001 10

问题：
用SQL 查询计算出每个订单的总金额，并按照订单号进行降序排列：订单号和订单总金额.

A. SELECT i.order_id, SUM(i.price) FROM test_order_item i group by i.`order_id`  order by i.order_id desc

B. SELECT order_id, price FROM test_order_item group by order_id and sum(price) order by order_id desc

C. SELECT order_id, SUM(price) FROM test_order_item group by order_id  order by order_id desc

D. SELECT order_id, SUM(price) FROM test_order_item group by order_id  order by order_id ASC