Pregunta de entrevista de Snowflake

Counting pairs which gave an array and integer