7、查询学过“张三“老师授课的同学的信息

7、查询学过"张三"老师授课的同学的信息

SELECT st.* FROM student st WHERE st.s_id IN (SELECT sc.s_id FROM score sc WHERE sc.c_id IN (SELECT c.c_id FROM course c,teacher t WHERE c.t_id=t.t_id AND t.t_name='张三'))