-- 34、查询课程名称为"数学",且分数低于60的学生姓名和分数(不重点)
SELECT st.s_name,st.s_id,co.c_name, sc.s_score FROM
student as st
INNER JOIN
score as sc on st.s_id=sc.s_id
INNER JOIN
course
-- 34、查询课程名称为"数学",且分数低于60的学生姓名和分数(不重点)
SELECT st.s_name,st.s_id,co.c_name, sc.s_score FROM
student as st
INNER JOIN
score as sc on st.s_id=sc.s_id
INNER JOIN
course