山东大学数据库实验六2015最新版

1.create view test6_01 as select sid,name,dname from pub.STUDENT where age<20 and dname='物理学院'order by sid
select * from test6_01
2.create view test6_02(sid,name,sum_score) 
as 
(select pub.student.sid,name,sum(score)
from pub.STUDENT,pub.STUDENT_COURSE 
where pub.STUDENT.SID=pub.student_course.sid
and dname='软件学院' 
and class=2009
group by pub.STUDENT.SID,name)
select * from test6_02
3.create view test6_03 as(
select pub.STUDENT.SID,pub.STUDENT.name,score
from pub.STUDENT,pub.STUDENT_COURSE,pub.COURSE
where pub.STUDENT.SID=pub.student_course.sid
and pub.STUDENT_COURSE.CID=pub.course.cid
and class=2010
and dname='计算机科学与技术学院' 
and pub.COURSE.NAME='操作系统')
select * fromm test6_03
4.create view test6_04 as
(select pub.STUDENT.SID,pub.STUDENT.NAME
from pub.STUDENT_COURSE,pub.STUDENT,pub.COURSE
where pub.STUDENT_COURSE.SID=pub.student.sid
and pub.STUDENT_COURSE.cid=pub.course.cid
and