查询任何一门课程成绩在70分以上的姓名、课程名称和分数

建表语句点击详见

– 查询任何一门课程成绩在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