SELECT stu.s_name ,s.s_score,c.c_name FROM student stu
JOIN score s ON stu.s_id =s.s_id
JOIN course c ON s.c_id=c.c_id
WHERE s.s_score<60
查询不及格的课程
最新推荐文章于 2023-01-10 17:58:07 发布
SELECT stu.s_name ,s.s_score,c.c_name FROM student stu
JOIN score s ON stu.s_id =s.s_id
JOIN course c ON s.c_id=c.c_id
WHERE s.s_score<60