Pregunta de entrevista de Apprenticely

What is a left vs right join in SQL?