在SQLServer中,有订单表orders用来存储订单信息,cid代表客户编号,money代表单次订购额,现要查询每个客户的订购次数和每个客户的订购总金额,下面()语句可以返回正确结果
A.selectcid,count(distinct(cid)),sum(money)fromordersgroupbycid
B.selectcid,count(distinct(cid)),sum(money)fromordersorderbycid
C.selectcid,count(cid),sum(money)fromordersorderbycid
D.selectcid,count(cid),sum(money)fromordersgroupbycid
D、selectcid,count(cid),sum(money)fromordersgroupbycid