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>70
查询任何一门课程成绩在70分以上的姓名、课程名称和分数
最新推荐文章于 2023-06-24 10:44:17 发布
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>70