mysql习题02

一张学生成绩表score，部分内容如下：
name       course     grade
张三        操作系统      67
张三        数据结构      86
李四        软件工程      89
用一条SQL 语句查询出每门课都大于80 分的学生姓名，SQL语句实现正确的是：（      ）

A: Select distinct name from score where name not in(Select name from score where grade <= 80);

B: Select distinct name from score where name  in(Select name from score where grade <= 80);

C: Select  name from score where name not in(Select name from score where grade <= 80);

D: Select  name from score where name  in(Select name from score where grade <= 80);

答案：A