– 查询不及格的课程
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
– 查询不及格的课程
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