查询所有学生的课程及分数情况

建表语句点击详见

– 查询所有学生的课程及分数情况

SELECT st.s_id, st.s_name, c.c_name, sc.s_score FROM student st LEFT JOIN score sc ON sc.s_id=st.s_id LEFT JOIN course c ON c.c_id =sc.c_id ORDER BY st.s_id,c.c_name