创建一个名为RS的视图,用来显示所有学生的学号、姓名和平均成绩,则下面正确的语句是______。
A.SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩;
WHERE STUDENT.学号=SKB.学号;
GROUP BY STUDENT.学号INTO CURSOR RS
B.CREATE VIEW RS AS;
SELECT STUDENT.学号,STUDENT.姓名,SKB.平均成绩;
WHERE STUDENT.学号=SKB.学号GROUP BY STUDENT.学号
C.SELECT STUDENT.学号,STUDENT.姓名,SKB平均成绩;
WHERE STUDENT.学号=SKB.学号;
GROUP BY STUDENT.学号INTO CURSOR RS
D.CREATE VIEW RS AS;
SELECT STUDENT.学号,STUDENT.姓名,AVG(SKB.成绩)AS平均成绩;
WHERE STUDENT.学号=SKB.学号GROUP BY STUDENT.学号