建表语句点击详见
– 查询任何一门课程成绩在70分以上的姓名、课程名称和分数
SELECT
st2
.s_id
,
st2
.s_name
,
c2
.c_name
,
sc2
.s_score
FROM student st2
LEFT JOIN score sc2
ON sc2
.s_id
=st2
.s_id
LEFT JOIN course c2
ON c2
.c_id
=sc2
.c_id
WHERE st2
.s_id
IN(
SELECT
st
.s_id
FROM student st
LEFT JOIN score sc
ON sc
.s_id
=st
.s_id
GROUP BY st
.s_id
HAVING MIN(sc
.s_score
)>=70)
ORDER BY s_id
