-- 35、查询所有学生的课程及分数情况；

科技2023-12-30 97

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

Processed: 0.012, SQL: 8