假设订单表orders用来存储订单信息，cid代表客户编号，money代表单次订购额

select cid,count(distinct(cid)),sum(money) from orders group by cid

select cid,count(distinct(cid)),sum(money) from orders order by cid

select cid,count(cid),sum(money) from orders order by cid

select cid,count(cid),sum(money) from orders group by cid