以下（ ）语句可查询选修了三门以上成绩在80分以上课程的学生学号。
选项：

A:select sno from scwhere grade>80group by snohaving count(cno)>3
B:select sno from scwhere grade>80group by snohaving count(*)>3
C:select sno from scwhere grade>80 and count(*)>3group by sno
D:select sno from scwhere grade>80group by snohaving count(sno)>3