Question d’entretien chez Goldman Sachs

How does Left join work?