Pergunta de entrevista da empresa Accenture

Question related to joins and arrays