Pergunta de entrevista da empresa Apprenticely

What is a left vs right join in SQL?