Pergunta de entrevista da empresa CME Group

What are joins and explain about left join