Cognizant Interview Question

sql left join question asked, combine two tables