Roche Interview Question

Questions about joins in SQL