有大佬帮忙看看这道数据库题目该怎么写吗？

Question

create view scoreView(Sno,Sname,dbScore,dsScore,Sum)
as
select Sno,Sname,first.Grade,second.Grade,sum(Grade)
from Student.Sno,Student.Sname,SC first,SC second,SC
where SC.Sno=student.Sno
and SC.Cno=course.Cno
and first.Sno=SC.Sno
and second.Sno=SC.Sno
and Course.Cname in(select Sname
                    from Course
                    where Cname='数据库' or Cname='数据结构');

上面那一段SQL语句会报错

Answer 1

第五行student S大写