SELECT st.s_id,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 AND c.c_name ="数学"
-- 34、查询课程名称为“数学“,且分数低于60的学生姓名和分数
最新推荐文章于 2022-12-08 19:12:52 发布