Pergunta de entrevista da empresa IDFC FIRST Bank

Question about joins, inner join, left outer join