Careate a view of average score.创建平均分视图

假定数据库中有三张表,student,sc,course,分别存有学生ID,学生名字;学生ID,课程ID,课程成绩;课程课程名称,现在要求求得每个学生的平均分,并创建视图,SQL代码如下:

create   view  Average  as
select  student.Name, AVG (sc.grade)  AS   ' Average '
from  student,sc,course
where  student.ID  =  sc.ID
and  sc.CourseID  =  course.CourseID
group   by  student.name;