Pergunta de entrevista da empresa Salesforce

SQL question for what's the different between the joins