SELECT stu.* FROM student stu WHERE stu.s_id IN (SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“张三” AND t.t_id=c.t_id AND c.c_id=s.c_id) AND stu.s_id IN (SELECT s.s_id FROM score s,teacher t,course c WHERE t.t_name=“李四” AND t.t_id=c.t_id AND c.c_id=s.c_id)
