用一条SQL语句 查询出每门课都大于80分的学生姓名

用一条SQL语句 查询出每门课都大于80分的学生姓名

 

name   kecheng   fenshu 

张三     语文            81

张三     数学            75

李四     语文            76

李四     数学            90

王五     语文            81

王五     数学           100

王五     英语            90 

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

select distinct name from student s where not exists (select * from student s2 where fenshu <= 80 and s2.name = s.name);