A: Sum(Grade)
B: Avg(Grade)
C: Min(Grade)
D: Max(Grade)
举一反三
- 查询统计选课表SC中成绩列Grade的最小值，可以用_______函数。 A: Min(Grade) B: Max(Grade) C: Avg(Grade) D: Sum(Grade)
- 查询统计选课表SC中成绩列Grade的总分，可以用_______函数
- 【单选题】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;
- 针对表SC（sno, cno, grade），其中sno为学号，cno为课程号，grade为成绩。以下哪个操作（ ）统计出每位学生所选课程的最高分和最低分。 A: select sno,max(grade), min(grade) from sc B: select sno,max(grade), min(grade) from sc order by sno C: select sno,max(grade), min(grade) from sc group by sno D: select sno,avg(grade), sum(grade) from sc group by sno
- 查询最低成绩大于85分的学生学号和平均成绩,可以使用的查询语句是: 。 A: SELECT Sno, AVG(Grade) FROM SC HAVING MIN(Grade) > 85 GROUP BY Sno; B: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING MIN(Grade) > 85; C: SELECT Sno, AVG(Grade) FROM SC WHERE MIN(Grade) > 85 GROUP BY Sno; D: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno WHERE MIN(Grade) > 85;
内容
- 0
查询001号学生选课成绩的平均分，总分，最高分，最低分Selectavg(grade),（）(grade),max(grade),min(grade)fromscwheresno=’001’
- 1
查询平均成绩小于70分的学生学号和平均成绩 A: SELECT Sno, AVG(grade) FROM SC GROUPBYSno B: SELECT Sno, AVG(grade) FROM SC GROUPBYSno HAVINGAVG(grade)<70; C: SELECT Sno, grade FROM SC GROUPBYSno HAVINGAVG(grade)<70;
- 2
在学生选课数据库中，查询平均成绩大于等于60分的同学，SQL语句为（ ） A: SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; B: SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno; C: SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60; D: SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;
- 3
统计学生成绩中的最高分，下列语句正确的是 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;
- 4
表sc中存放了多个学生的多门课程的成绩，sno为学号，cno为课程号，grade为成绩。要查询平均分最高的学生学号和平均分，下列（）语句可以实现。 A: SELECT top 1 sno,avg(grade) FROM sc group by sno order by avg(grade) desc B: SELECT sno,max(avg(grade)) FROM sc group by sno C: SELECT sno,max(grade), avg(grade) FROM sc group by sno D: SELECT sno,max(grade) FROM sc group by sno