Pergunta de entrevista da empresa IBM

Write query for left join in SQL between 2 tables