若要求“查询选修了 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