【C400165】在MySQL中，现有分数表scores设计如下： courseID(课程编号) studentID(学生编号) score(分数)  另有一个学生信息表student，包含studentID，sname(学生姓名)。  已知并非所有学生都参加了考试，现在查询所有及格学生的学生姓名，下面正确的是（  ）。

• A.select sname from student where exists (select studentID from score where score>60) 

• B.select sname from student where studentID  not in (select studentID from score where score<60) 

• C.select sname from student where studentID = (select studentID from score where score>60) 

• D.select sname from student where studentID  in (select studentID from score where score>=60)