查询每门课都大于90分的同学的姓名:
SELECT name FROM grade GROUP BY name HAVING MIN(score)>90;
查询平均分大于80的学生的姓名:
SELECT name, avg(score) as sc FROM grade GROUP BY name HAVING avg(score)>80 ;
查询每门课都大于90分的同学的姓名:
SELECT name FROM grade GROUP BY name HAVING MIN(score)>90;
查询平均分大于80的学生的姓名:
SELECT name, avg(score) as sc FROM grade GROUP BY name HAVING avg(score)>80 ;