Pergunta de entrevista da empresa PowerPlan

Difference between a outer and inner join? Give me general idea of how you would write this code? Why this company? Challenges with a specific project?