麻烦大家给我看下这个SQL语句出现了什么问题,谢谢!

select grade,cno=2 from sc group by cno having count(grade)>=90
--25)查询选修2号课程且成绩在90分以上的所有学生。

谢谢啦。。

select grade,cno from sc where cno = 2 and grade >= 90

select grade,cno from sc where cno=2 group by cno having count(grade)>=90

楼上正解,不回复了。。。