只写了一半，剩下的写不来了，求指导

Question

select score.课程号,课程名,学号,成绩
from score
left join course on course.课程号=score.课程号

Answer 1

望采纳哈，谢谢

select  a.课程号,a.课程名,c.学号,b.成绩
from course a
left join score b on b.课程号=a.课程号
left join student c on c.学号=b.学号