建表语句点击详见
– 查询"01"课程比"02"课程成绩高的学生的信息及课程分数
SELECT
st
.*,
sc
.s_score
AS '语文',
sc2
.s_score
AS '数学'
FROM
student st
LEFT JOIN score sc
ON sc
.s_id
=st
.s_id
AND sc
.c_id
='01'
LEFT JOIN score sc2
ON sc2
.s_id
=st
.s_id
AND sc2
.c_id
='02'
WHERE sc
.s_score
>sc2
.s_score
