Meander Software interview question

3. SQL query of inner join and left join.