建表语句点击详见
– 查询选修"张三"老师所授课程的学生中，成绩最高的学生信息及其成绩
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
