查询不及格的课程

建表语句点击详见

– 查询不及格的课程

SELECT st.s_id, c.c_name, st.s_name, sc.s_score FROM student st INNER JOIN score sc ON sc.s_id=st.s_id AND sc.s_score<60 INNER JOIN course c ON c.c_id=sc.c_id