相当于是group by汇总以后的where过滤,
只不过这里不用where 而是用having。 That's all.
having 对分组进行过滤
SELECT TeacherID, AVG(Age) AS AGE FROM Student
GROUP BY TeacherID
HAVING AVG(Age) > 12
老师id 分组 结果集为 平均年龄大于12 的结果集
--补充
select ··· from ···
where ···(只能对分组前的属性进行筛选)
group by ···
having ···(只能对分组后的每个组的整体属性进行筛选,用聚合函数体现)
····
--不使用group by就默认表的整体为一组