Codebox interview question

Question related to join operation