表：student(sno,sname,ssex,sbirthday,class)

select sname from student
where sno in (
select student.sno from student,score,course,teacher //这里的忘记加了
where student.sno=score.sno
and course.cno=score.cno
and teacher.tno=course.tno
and teacher.tno in (
select teacher.tno from student,score,course,teacher
where student.sno=score.sno
and course.cno=score.cno
and teacher.tno=course.tno
and student.sname='小王'
)
and student.class not in(select class from student where sname='小王')
)