单项选择题
在学生选课数据库中,查询平均成绩大于等于60分的同学,SQL语句为( )
A、SELECT Sno, AVG(Grade) FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
B、SELECT Sno FROM SC WHERE Grade>=60 GROUP BY Sno;
C、SELECT Sno, Grade FROM SC GROUP BY Sno HAVING AVG(Grade)>=60;
D、SELECT Sno FROM SC GROUP BY Sno HAVING Grade >=60;
点击查看答案&解析
相关考题
