题目：创建管理系选修了a001号课程的学生的视图guanlixi_view ( )
create view guanlixi_view as select * from student,sc where cid=’a001’ and depart=’管理系’
create view guanlixi_view as select student.*,sc.cid from student,sc where cid=’a001’ and depart=’管理系’
create view guanlixi_view as select student.*, sc.cid from student,sc where cid=’a001’ and depart=’管理系’ and student.stuid=sc.stuid
create viewguanlixi_view as select student.*, sc.cid from course,sc where cid=’a001’ and depart=’管理系’ and course.stuid=sc.stuid
