统计学生成绩中的最高分，下列语句正确的是
A: SELECT AVG(grade) FROM student;
B: SELECT (SUM(grade) / Count(id)) FROM student;
C: SELECT MAX(grade) FROM student;
D: SELECT MIN(grade) FROM student;
A: SELECT AVG(grade) FROM student;
B: SELECT (SUM(grade) / Count(id)) FROM student;
C: SELECT MAX(grade) FROM student;
D: SELECT MIN(grade) FROM student;
举一反三
- 【单选题】5. 假定student表中有字段grade,grade代表分数,依次统计grade字段的最大值,最小值,平均值的SQL语句是 A. SELECT max(grade),min(grade),average(grade) FROM student; B. SELECT max(grade),min(grade),avg(grade) FROM student; C. SELECT min(grade),average(grade),max(grade) FROM student; D. SELECT min(grade),avg(grade),max(grade) FROM student;
- 按照学号进行分组，统计学生的平均成绩（） A: select sid, avg(grade) from student group by cid B: select sid, avg(grade) from student group by sid C: select sid, avg(grade) from sc group by sid D: select sid, avg(grade) from sc group by cid
- 按照课程号进行分组，统计学生平均成绩大于60分的学生的信息( ) A: select cid,avg(grade) from sc group by cid having avg(grade)>60 B: select cid,avg(grade) from student group by cid having avg(grade)>60 C: select cid,avg(grade) from course where avg(grade)>60 group by cid D: select cid,avg(grade) from student where avg(grade)>60 group by cid
- 按照学号进行分组，统计学生的平均成绩，且平均分按降序排列 A: select sid, avg(grade) from sc group by sid order by avg(grade) desc B: select sid, avg(grade) from sc group by cid order by avg(grade) desc C: select sid, avg(grade) from student group by sid order by avg(grade) desc D: select sid, avg(grade) from student group by cid order by avg(grade)
- 对于学生信息表：student(sno，sname，sex，age，grade)，查询学习成绩为空的学生的学号和姓名，下面语句正确的是 A: SELECT sno，sname FROM student WHERE grade=NULL B: SELECT sno，sname FROM student WHERE grade IS NULL C: SELECT sno，age FROM student WHERE grade IS NULL D: SELECT sno，age FROM student WHERE grade=NULL