[单选题]

有关系模式SC(S#,C#,GRADE),各属性分别表示学号、课程号、成绩,则“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是( )。

A.SELECT S# FROM SC GROUP BY S# WHERE COUN(*)>3

B.SELECT S# FROM SC GROUP BY S# HAVING COUN(*)>3

C.SELECT S# FROM SC ORDER S# HAVING COUN(*)>3

D.SELECT S# FROM SC ORDER S# WHERE COUN(*)>3

参考答案与解析: