SQL面试50题-36
36、查询任何一门课程成绩在70分以上的姓名、课程名称和分数(重点
SELECT st.s_name,co.c_name,sc.s_score FROM Student st INNER JOIN Score sc ON sc.s_id = st.s_id INNER JOIN Course co ON co.c_id = sc.c_id WHERE sc.s_score > 70
36、查询任何一门课程成绩在70分以上的姓名、课程名称和分数(重点
SELECT st.s_name,co.c_name,sc.s_score FROM Student st INNER JOIN Score sc ON sc.s_id = st.s_id INNER JOIN Course co ON co.c_id = sc.c_id WHERE sc.s_score > 70
相关推荐