select
    coalesce(a.name, b.name) as name,
    a.boat,
    b.instrument
from
    sailor a
    full outer join
    musician b
    on a.name = b.name;