【单选题】创建一个视图NPStuView,记录各课程考试有不及格的学生信息(包括:学号Sno,姓名Sname,课程号Cno,课程名Cname,成绩Grade)。则,该视图创建语句为( )
A.
CREATE View NPStuView AS SELECT Sno, Sname, Cno, Cname, Grade from Student, SC, Course WHERE Grade<60;
B.
CREATE View NPStuView (Sno, Sname, Cno, Cname, Grade) AS SELECT Student.Sno, Sname, Course.Cno, Cname, Grade from Student, SC, Course WHERE Student.Sno=SC.Sno and SC.Cno=Course.Cno and Grade<60;
C.
CREATE View NPStuView AS SELECT Student.Sno, Sname, Course.Cno, Cname, Grade from Student, SC, Course WHERE Student.Sno=SC.Sno and SC.Cno=Course.Cno and Grade<60;
D.
CREATE View NPStuView (Sno, Sname, Cno, Cname, Grade) SELECT Student.Sno, Sname, Course.Cno, Cname, Grade from Student, SC, Course WHERE Student.Sno=SC.Sno and SC.Cno=Course.Cno and Grade<60;