![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-53/ti_inject-812ce.png)
实现“查询选课总数超过两门的学生的学号及选课总数”的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, SUM(Cno) FROM SC ORDER BY Sno HAVING COUNT(Cno)>2
D.
SELECT Sno, COUNT(Cno) FROM SC GROUP BY Sno HAVING COUNT(Cno)>2