MYSQL学习过程中遇到的多表联查的问题

Question

MYSQL语言问题，数据如下：

如何能得到如下结果：

使用多表联查得不出来结果

Answer 1

select a.,b.,c.,d. from Student a
left join (select * from Score where Cno = '3-105') b
on a.sno=b.sno
left join (select * from Score where Cno = '6-166') c
on a.sno=c.sno
left join (select * from Score where Cno = '3-245') d
on a.sno=d.sno