Try:

select s.sname, p.pname
from s
join sp on sp.snr = s.snr
join p on sp.pnr = p.pnr
where p.color = 'blue'