select sno,sname from student where sno not in
(select sno from sc a,course b,teacher c where a.cno=b.cno and b.tno=c.tno and tname='谌燕') a
(select sno from sc a,course b,teacher c where a.cno=b.cno and b.tno=c.tno and tname='谌燕') a
FROM student
WHERE sno IN ( SELECT sno
FROM sc
WHERE cno IN ( SELECT cno
FROM course
WHERE tno NOT IN ( SELECT tno
FROM teacher
WHERE tname <> '谌燕' ) ) )