单选题

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