group by having

查询每门课都大于80分的同学的姓名：

SELECT name FROM grade GROUP BY name HAVING MIN(score) > 80;

查询平均分大于80的学生的姓名：

select name, avg(score) as sc from grade g1 group by name having avg(score)>80 ;