单项选择题

下列利用SC表的查询语句中,错误的是()

A.SELECT Sno,COUNT(*)FROM SC GROUP BY Sno
B.SELECT Sno FROM SC GROUP BY Sno HAVING COUNT(*)>3
C.SELECT Sno FROM SC GROUP BY Sno WHERE COUNT(*)>3
D.SELECT Sno FROM SC GROUP BY Sno