“学生—选课—课程”数据库中的三个关系：
S(S#, SNAME, SEX, AGE, DEPT)
SC(S#, C#, GRADE)
C(C#, CNAME, TEACHER)
其中S的主码是S#, SC的主码是(S#, C#)，C的主码是C#。

查找选修了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