Get the average socre of the student.(The exmaple of group, having and order by).求学生平均分(group, having 和 order by使用示例).

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

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  having   AVG (sc.grade)  >=   80
order   by  Average  desc ;