Cognizant interview question

sql left join question asked, combine two tables