查询分数不低于80分的学生

表如下：

查询分数大于60分的学生姓名

1、select name from sc group by name having(或者用where) name not in(select name from sc where score<80);

2、select name from sc group by name having min(score)>=80