Goldman Sachs Interview Question

How does Left join work?