Course表如下：

查询出每门课都大于80 分的学生姓名有两种方法。

1.select  distinct name from Course where name not in (select distinct name from Course where score<=80) 

2.select  name    from Course group by name having min(score)>80

SQL查询出每门课都大于80 分的学生姓名