【单选题】S(学号,姓名,性别,年龄,系部),C(课程号,课程名),SC(学号,课程号,成绩) 创建视图S_view,显示学生姓名,课程名,成绩,正确的SQL语句为()
A.
create view s_view as select 姓名,课程名,成绩 from S ,C ,SC where s.学号=sc.学号 and c.课程号=SC.课程号
B.
alter view s_view as select 姓名,课程名,成绩 from S ,C ,SC where s.学号=sc.学号 and c.课程号=S