-
找到每门课都大于80的学生姓名
NAME Course Score
Mike Math 88
Sara Science 70
Mike Science 70
Mike PE 60
select distinct 1.name
from student 1
where 1.name not in (
select distinct 2.name
from student 2
where 2.score<=80)
反向思维—选取score>80 可以先筛选score<80的学生姓名
但是要加distinct
NOT In 效率低于Join on
i.e.
select 1.name
from student 1
join (
select 2.name
from student 2
where score < 80
) 3
on 1.name = 3.name
where 3.name is null