CREATE VIEW SCC
AS SELECT sname,cname,score=score+5
FROM STUDENTS,COURSES,CHOICES
WHERE STUDENTS.SID=CHOICES.SID AND dbo.COURSES.cid=dbo.CHOICES.cid
CREATE VIEW SCC
AS SELECT sname,cname,score=score+5
FROM STUDENTS,COURSES,CHOICES
WHERE STUDENTS.SID=CHOICES.SID AND dbo.COURSES.cid=dbo.CHOICES.cid