-- 40、查询选修“张三“老师所授课程的学生中，成绩最高的学生信息及其成绩

SELECT st.*,c.c_name,sc.s_score,t.t_name FROM student st INNER JOIN score sc ON sc.s_id=st.s_id INNER JOIN course c ON c.c_id=sc.c_id INNER JOIN teacher t ON t.t_id=c.t_id AND t.t_name="张三" ORDER BY sc.s_score DESC LIMIT 0,1