select name from stu where name not in(select name from stu wherefenshu<=80 group by name havingcount(*)>肢冲扰=1) group by name先查到任何一门不足80的学生，历旦再排除这判雀些学生
