单项选择题

该题基于“学生-选课-课程”数据库中的3个关系。
学生基本信息S(S#,SNAME, SEX, AGE)
选课信息SC(S#, C#, GRADE)
课程信息C(C#, CNAME, TEACHER)
若要求“查询选修了3门以上课程的学生的学生号”,正确的SQL语句是( )。

A.SELECT S# FROM SC GROUP BY S# WHERE COUNT (*)>3
B.SELECT S# FROM SC GROUP BY S# HAVING COUNT(*)>3
C.SELECT S# FROM SC ORDER BY S# WHERE COUNT(*)>3
D.SELECT S# FROM SC ORDER BY S# HAVING COUNT(*)>3