在MySQL中,假设有 学生选课表SC(sno,cno,score)。那么列出所有选修课程超过5门的 学生以及选修课程数目,其正确的SQL语句为( )。
A.
select sno,count(cno) from sc where count(cno)>=5;
B.
select sno,count(cno) from sc group by sno where count(cno)>=5;
C.
select sno,count(cno) from sc group by sno having count(cno)>=5;
D.
select sno,count(cno) from sc group by cno having count(cno)>=5;