假定数据库中有三张表,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;
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;