mysql如何对求出的平均值筛选

Question

select sc.Sno,Sname,avg(Grade)平均成绩
from student right outer join sc
on student.Sno=sc.Sno
group by Sno
order by sno;

我想输出的平均值＞65

Answer 1

先分组求出平均成绩，再筛选 用having子句

select sc.Sno,Sname,avg(Grade)平均成绩
from student right outer join sc
on student.Sno=sc.Sno
group by Sno,Sname  having avg(Grade)>65
order by sno;