题目
第2题
要选出平均成绩超过80分的学生的学号和平均成绩,下列正确的语句是___
A SELECT 学号,平均成绩 FROM SKB WHERE 平均成绩>=80
B SELECT 学号,AVG(成绩) AS 平均成绩 FROM SKB WHERE 平均成绩>=80
C SELECT 学号,AVG(成绩) AS 平均成绩 FROM SKB GROUP BY 学号 HAVING 平均成绩>=80
D SELECT 学号,AVG(成绩) AS 平均成绩 FROM SKB ORDER BY 学号 HAVING 平均成绩>=80
第3题
查询选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是
A.SELECT s.学号,姓名,平均成绩FROM student s,score sc WHERE s.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5 ORDER BY平均成绩DESC
B.SELECT学号,姓名,AVG(成绩)FROM student s,score sc WHERE s.学号=sc.学号AND COUNT(*)>=5 GR0UP BY学号ORDER BY 3 DESC
C.SELECT s.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc wHERE s.学号=sc.学号AND COUNT(*)>=5 GROUP BY s.学号ORDER BY平均成绩DESC
D.SELECT s.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc WHERE s.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5ORDER BY 3 DESC
第4题
SELECT学号,姓名,(59)
FROM Student
GROUP BY(60)
HAVING(61)
(59)A.SUM(成绩)
B.AVG(SUM(成绩))
C.AVG(成绩)AT平均成绩
D.AVG(成绩)AS平均成绩
(60)A.学号
B.姓名
C.系名
D.课程号
(61)A.COUNT(DISTINCT学号)>3
B.COUNT(课程号)>3
C.COUNT(DISTINCT学号)>=3
D.COUNT(课程号)>=3
第5题
查询选修课程在5门以上(含5门)的学生的学号、姓名和平均成绩,并按平均成绩降序排序,正确的命令是()。
A.SELECT S.学号,姓名,平均成绩FROM student s,score sc WHERE S.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5 ORDER BY平均成绩DESC
B.SELECT s.学号,姓名,AVG(成绩)FROM student s,score sc WHERE s.学号=SC.学号AND COUNT(*)>=5 GRoUP BY学号0RDER BY 3 DESC
C.SELECT S.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc WHERE s.学号=SC.学号AND COUNT(*)>=5 GROUP BY s.学号ORDER BY平均成绩DESC
D.SELECT s.学号,姓名,AVG(成绩)平均成绩FROM student s,score sc WHERE s.学号=sc.学号 GROUP BY s.学号HAVING COUNT(*)>=5 0RDER BY 3 DESC
为了保护您的账号安全,请在“赏学吧”公众号进行验证,点击“官网服务”-“账号验证”后输入验证码“”完成验证,验证成功后方可继续查看答案!