查询每门课都大于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 ;
查询每门课都大于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 ;