下列SQL语句中，_____________可以在“学生-课程”数据库正确实现“计算1号课程的学生平均成绩”。
A: SELECT AVG(Grade)FROM SCWHERE Cno= ' 1 '
B: SELECT MAX(Grade)FROM SCWHERE Cno= 1
C: SELECT MIN(Grade)FROM SCWHERE Cno= 1
D: SELECT AVG(Grade)FROM SCWHERE Cno= 1
A: SELECT AVG(Grade)FROM SCWHERE Cno= ' 1 '
B: SELECT MAX(Grade)FROM SCWHERE Cno= 1
C: SELECT MIN(Grade)FROM SCWHERE Cno= 1
D: SELECT AVG(Grade)FROM SCWHERE Cno= 1
举一反三
- 针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（ ）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select sno from scwhere grade>90group by snohaving count(cno)>2 B: select sno from scwhere grade>90group by snohaving count(*)>2 C: select sno from scwhere grade>90 and count(*)>2group by sno D: select sno from scwhere grade>90group by snohaving count(sno)>2
- 查询没有选修1号课程的学生姓名（）。 A: select snamefrom student,scwhere student.sno=sc.sno and cno!='1' B: select snamefrom sno not in(select snofrom scwhere cno='1' ) C: select snamefrom sno in(select snofrom scwhere cno!='1' ) D: select snamefrom sno not exists(select*from scwhere student.sno and sc.sno and cno='1' )
- 下列SQL语句中，________可以在“学生-课程”数据库中实现“查询所有有成绩的学生学号和课程号”。 A: SELECT Sno，Cno FROM SC WHERE Grade <> NULL B: SELECT Sno，Cno FROM SC WHERE Grade NOT NULL C: SELECT Sno，Cno FROM SC WHERE Grade >0 D: SELECT Sno，Cno FROM SC WHERE Grade IS NOT NULL
- 针对学生选课表sc（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下（）语句可查询选修了两门以上成绩在90分以上课程的学生学号。 A: select snofrom scwhere grade>;90group by snohaving count(cno)>;2 B: select snofrom scwhere grade>;90group by snohaving count(*)>;2 C: select snofrom scwhere grade>;90 and count(*)>;2group by sno D: select snofrom scwhere grade>;90group by snohaving count(distinct sno)>;2
- 检索选修了课程”C1”的学生中成绩最高的学生的学号，正确的SELECT语句为（ ） A: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >=ALL (SELECT Grade FROM SC WHERE Cno=’C1’); B: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE IN (SELECT Grade FROM SC WHERE Cno=’C1’); C: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE > ANY (SELECT Grade FROM SC WHERE Cno=’C1’); D: SELECT Sno FROM SC WHERE Cno=’C1’ AND GRADE >= (SELECT Grade FROM SC WHERE Cno=’C1’);