1.4.3.sql

清华大学出版社出版的数据库系统教程附带的实验教程中所有的源代码

CREATE VIEW SCC
(SNAME,CNAME,SCORE)
AS SELECT STUDENTS.SNAME,COURSES.CNAME,CHOICES.SCORE+5
FROM CHOICES,STUDENTS,COURSES
WHERE CHOICES.CID=COURSES.CID AND CHOICES.SID=STUDENTS.SID