单选题

查询选修了3门以上课程的学生的学生号，正确的SQL语句是

Question

A. SELECT Sno FROM SC GROUP BY Sno WHERE COUNT（*）> 3

B. SELECT Sno FROM SC GROUP BY Sno HAVING( COUNT（*）> 3)

C. SELECT Sno FROM SC ORDER BY Sno WHERE COUNT（*）> 3

D. SELECT Sno FROM SC ORDER BY Sno HAVING COUNT（*）>= 3