对应课程:点击查看
本课程任课教师为：史霄波;窦智;程向羽
起止时间:2018-05-21到2018-05-25
更新状态:已完结
第三章 关系数据库标准语言SQL 单表查询
1、 从学生成绩表SC中查询平均成绩大于60分的同学的学号和平均成绩的正确语句为：
A:select sno,avg(score) as sscore from sc group by sno having avg(score) >60
B:select sno,avg(score) as sscore from sc group by sno where avg(score) >60
C:select sno,avg(score) as sscore from sc where avg(score) >60
D:select sno,avg(score) as sscore from sc having avg(score) >60
答案: select sno,avg(score) as sscore from sc group by sno having avg(score) >60
2、 从学生表student中查询所有学生的学号，姓名，年龄的正确语句为：
A:select sno,sname,ssex from student
B:select sno sname ssex from student
C:select 学号 sno,姓名 sname,性别 ssex from student
D:select sno 学号,sname 姓名,ssex 性别 from student
答案: select sno,sname,ssex from student
3、 从sc表中查询了选修课程的学生学号，去掉重复行的正确语句为
A:select sno from sc
B:select sno from sc where cno=’1’ or cno=’2’ or cno=’3’
C:select distinct sno,’学号’ from sc
D:select sno from sc where cno<>null
答案: select distinct sno,’学号’ from sc
4、 从student表中查询姓”李”的同学的学号，姓名，年龄
A:select sno,sname,sage from student where sname like “李%”
B:select sno,sname,sage from student where sname=“李%”
C:select * from student where sname like “%明__”
D:select * from student where sname like “明”
答案: select sno,sname,sage from student where sname like “李%”
5、 查询姓名中有“明”字的所有同学的信息
A:select * from student where sname like “%明%”
B:select * from student where sname like “明%”
C:select * from student where sname like “%明”
D:select * from student where sname like “明”
答案: select * from student where sname like “%明%”
6、 查询成绩在70到80分之间的学生的学号、课程号和成绩
A:select sno 学号,cno 课程号,grade 成绩from scwhere grade between 70 and 80
B:select sno 学号,cno 课程号,grade 成绩from scwhere 70<=grade<=80
C:select sno 学号,cno 课程号,grade 成绩from scwhere grade>=70 or grade<=80
D:select sno 学号,cno 课程号,grade 成绩from schaving grade>=70 and grade<=80
答案: select sno 学号,cno 课程号,grade 成绩from scwhere grade between 70 and 80
7、 统计选修课的学生总数和考试的平均成绩
A:select count(distinct(sno)) as 学生总数，avg(grade) as 平均成绩from sc
B:select count(sno) as 学生总数，avg(grade) as 平均成绩from sc
C:select count(sno) as 学生总数，avg(grade) as 平均成绩from scgroup by sno
D:select distinct count(sno) as 学生总数，avg(grade) as 平均成绩from sc
答案: select count(distinct(sno)) as 学生总数，avg(grade) as 平均成绩from sc
为了方便下次阅读，建议在浏览器添加书签收藏本网页
添加书签方法：
1.电脑按键盘的Ctrl键+D键即可收藏本网页
2.手机浏览器可以添加书签收藏本网页
获取更多MOOC答案，欢迎在浏览器访问我们的网站：http://mooc.mengmianren.com
注：请切换至英文输入法输入域名，如果没有成功进入网站，请输入完整域名：http://mooc.mengmianren.com/
我们的公众号
打开手机微信，扫一扫下方二维码，关注微信公众号：萌面人APP
本公众号可查看各种网课答案，还可免费查看大学教材答案
点击这里，可查看公众号功能介绍
一键领取淘宝，天猫，京东，拼多多无门槛优惠券，让您购物省省省，点击这里，了解详情
干饭人福利，饿了么红包每日领
