ARRB Systems Interview Question

some SQL questions: inner join, left join.