建表语句点击详见
– 查询任何一门课程成绩在70分以上的姓名、课程名称和分数
SELECT st2.s_id,st2.s_name,c2.c_name,sc2.s_score FROM student st2LEFT JOIN score sc2 ON sc2.s_id=st2.s_idLEFT 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