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
-- 36、查询任何一门课程成绩在70分以上的姓名、课程名称和分数
最新推荐文章于 2023-06-24 10:44:17 发布