Capgemini interview question

SQL joins, questions from my core branch.