假定学生关系是S(SNo,SName,Sex,Age)，课程关系是C(CNo,CName,Teacher)，学生选课关系是SC(SNo,CNo,Grade)。要查找选修4门以上(含4门)课程的学生总成绩(不统计不及格的课程)，只输出学生学号和总成绩，正确的SQL语句是()

单选题

SELECT Sno,SUM(Grade) FROM SC WHERE Grade>=60 GROUP BY Sno HAVINGCOUNT(*)>=4

SELECT Sno,COUNT(*),SUM(Grade) FROM SC GROUP BY Sno HAVING Grade>=60 andC OUNT(*)>=4

SELECT Sno,COUNT(*),SUM(Grade)FROM SC WHERE Grade>=60 GROUPBY Sno HAVING COUNT(*)>=4

SELECT Sno,SUM(Grade)FROM SC WHERE Grade>=60 and COUNT(*)>=4 GROUP BY Sno

上一题

下一题

题目信息

校招真题

正确率

点击

我的笔记