Apprenticely Interview Question

What is a left vs right join in SQL?