MyMind interview question

A case about joins on SQL.