-- 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 as co on sc.c_id=co.c_id
WHERE co.c_name='数学' and sc.s_score<60
34、查询课程名称为数学,且分数低于60的学生姓名和分数(不重点)(自己做出)
最新推荐文章于 2023-02-22 17:00:23 发布