假设订单表orders用于存储订单信息,cid代表客户编号,money代表订购金额,现要查询每个客户的订购次数和每个客户的订购总金额,则下列( )SQL语句可以返回正确的结果。
A.
select cid,count(distinct(cid)),sum(money) from orders group by cid
B.
select cid,count(distinct(cid)),sum(money) from orders order by cid
C.
select cid,count(cid),sum(money) from orders order by cid
D.
select cid,count(cid),sum(money) from orders group by cid