Snowflake Interview Question

Counting pairs which gave an array and integer