ARRB Systems interview question

some SQL questions: inner join, left join.