实现“查询选课总数超过两门的学生的及选课总数”的SELECT语句为()
A.
SELECT Sno, COUNT(Cno) FROM SC ORDER BY Sno HAVING COUNT(Cno)>2
B.
SELECT Sno, SUM(Cno) FROM SC GROUP BY Sno HAVING COUNT(Cno)>2
C.
SELECT Sno, COUNT(Cno) FROM SC GROUP BY Sno HAVING COUNT(Cno)>2
D.
SELECT Sno, SUM(Cno) FROM SC ORDER BY Sno HAVING COUNT(Cno)>2