Pergunta de entrevista da empresa Double Line

What is a left join, what is a materialized view etc