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

SELECT st.* FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id LEFT JOIN course c ON c.c_id=sc.c_id LEFT JOIN teacher t ON t.t_id=c.t_id WHERE t.t_name="张三";