-- 40、查询选修“张三”老师所授课程的学生中成绩最高的学生姓名及其成绩(重要top)
SELECT st.s_name,sc.s_score FROM
student as st
INNER JOIN
score as sc on st.s_id=sc.s_id
INNER JOIN
course as co on sc.c_id=co.
-- 40、查询选修“张三”老师所授课程的学生中成绩最高的学生姓名及其成绩(重要top)
SELECT st.s_name,sc.s_score FROM
student as st
INNER JOIN
score as sc on st.s_id=sc.s_id
INNER JOIN
course as co on sc.c_id=co.