IDFC FIRST Bank Interview Question

Question about joins, inner join, left outer join