Goldman Sachs Interview Question

Situational example on joins in SQL