COUNT (DISTINCT ORIGIN_FROM_ADDRESS) AS "DISTINT WALLETS DEPOSITER",

sum(event_inputs:amount)/1000000 as "Amount of USDC depoisted", -- To calculate amount of USDC deposited

"Amount of USDC depoisted"/"DISTINT WALLETS DEPOSITER" as "Average Deposit by user"

from ethereum.core.fact_event_logs

where ORIGIN_TO_ADDRESS =lower ('0xd89a09084555a7d0abe7b111b1f78dfeddd638be') --contract address for USDC pool for Pooltogether

AND BLOCK_TIMESTAMP >= CURRENT_DATE - 30 --last month

AND event_name= 'Deposit' -- to distinct type of transaction using event_type