首页 > 计算机类 > 等级考试 > 计算机二级 > MySQL数据库程序设计 > 设有学生表 Student( 学号,姓名,系名,课程号,成绩 ),查询至少选修了 4 门课程的学生学号及平均 成绩的正确语句是 ______。

设有学生表 Student( 学号,姓名,系名,课程号,成绩 ),查询至少选修了 4 门课程的学生学号及平均 成绩的正确语句是 ______。

A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
查看答案
正确答案: A
答案分析:
包含此试题的试卷:
相关的试题
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
A.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >3
B.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(课程号 ) >3
C.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY学号 HAVING COUNT(课程号 ) >4
D.SELECT学号, AVG(成绩 ) AS 平均成绩 FROM StudentGROUP BY课程号 HAVING COUNT(DISTINCT学号 ) >3
网站内容收集于网络,如有侵犯您的权益,请联系:gl@lm158.com,感谢您的支持
神奇助手题库网