智慧职教: select * from stu s join class c on s.cid=cid 与此语句查询结果一致的是（）

查询选修了a001号课程的学生的最高成绩（） A: select cid, max(grade) from course where cid=’a001’ group by cid B: select cid,max(grade) from student where cid=’a001’ group by cid C: select cid, max(grade) from sc where cid=’a001’ group by cid D: select cid, max(grade) from student group by cid having cid=’a001’

统计选修了a001课程的学生的平均成绩( ) A: select cid,avg(grade) from student group by cid having cid=’a001’ B: select cid,avg(grade) from student where cid=’a001’ group by cid C: select cid,avg(grade) from course where cid=’a001’ group by cid D: select cid,avg(grade) from sc where cid=’a001’ group by cid

按课程号分类，统计相应的选课人数（） A: select cid, count(distinct sid) from sc group by cid B: select cid, count(*) from student group by cid C: select cid, count(distinct cid) from sc group by cid D: select cid, count(distinct sid) from student group by cid

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

DeviceNet是基于连接的网络，下列属于报文组1的连接标识符（CID）是（）。 A:  CID=300 hex B:  CID=400 hex C:  CID=500 hex D:  CID=600 hex

Mes amis ont décidé de ( ) cet enfant. A: d'adopter B: d'adapter C: de s'adopter à D: de s'adapter à

为salerecord表CID字段添加外键，引用client表中CID字段。 A: ALTER TABLE salerecord ADD CONSTRAINT fk1 FOREIGN KEY(CID) REFERENCES client(CID); B: ALTER TABLE salerecord ADD CONSTRAINT pk1 PRIMARY KEY(CID) REFERENCES client(CID); C: ALTER TABLE salerecord ADD CONSTRAINT fk1 FOREIGN KEY(CID) REFERENCES client(CID),ADD CONSTRAINT pk2 PRIMARY KEY(GID) REFERENCES goods(GID); D: ALTER TABLE salerecord ADD CONSTRAINT pk1 PRIMARY KEY(CID) REFERENCES client(CID),ADD CONSTRAINT pk2 PRIMARY KEY(GID) REFERENCES goods(GID);

按照课程号进行分组，统计学生平均成绩大于60分的学生的信息( ) A: select cid,avg(grade) from sc group by cid having avg(grade)>60 B: select cid,avg(grade) from student group by cid having avg(grade)>60 C: select cid,avg(grade) from course where avg(grade)>60 group by cid D: select cid,avg(grade) from student where avg(grade)>60 group by cid

设有学生表S（S#，NAME，CLASS）和学生选修表SC（SC#,CID,GRADE），为维护数据一致性，表S与SC之间应满足 约束。