Roche interview question

Questions about joins in SQL