C) select cid,count(cid),sum(money) from orders order by cid D) select cid,count(cid),sum(money) from orders group by cid
49）、创建一个名为‘Customers’的新表，同时要求新表中包含表‘clients’的所有记录，sql语句是（ ）。（选择一项）
A) Select * into customers from clients B) Select into customers from clients C) Insert into customers select * from clients D) Insert customers select * from clients
50）、SELECT * FROM STUDENT WHERE AGE BETWEEN 20 等价于下列哪一条语句（ ）
A、SELECT * FROM STUDENT WHERE AGE IN(10，20) B、SELECT * FROM STUDENT WHERE AGE>10 AND AGE<20 C、SELECT * FROM STUDENT WHERE AGE>=10 AND AGE<20
D、SELECT * FROM STUDENT WHERE AGE>=10 AND AGE<=20
AND 10