Pergunta de entrevista da empresa Net eSolutions

how would i iterate through an array? JOIN statements in SQL