Goldman Sachs interview question

Situational example on joins in SQL