查询没学过 “ 谌燕 ” 老师课的同学的学号、姓名; 相关知识点: 试题来源: 解析 select * from student st where st.sno not in (select distinct sno from sc s join course c on s.cno=c.cno join teacher t on c.tno=t.tno where tname=' 谌燕 ') ...