设有学生表 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