SELECT

FROM_ADDRESS,

COUNT(DISTINCT TX_HASH) AS tx_count

FROM

polygon.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= DATEADD(DAY, -60, CURRENT_TIMESTAMP())

AND BLOCK_TIMESTAMP <= CURRENT_TIMESTAMP()

GROUP BY

FROM_ADDRESS

SELECT

COUNT(*) AS total_active_users

FROM

User_Transactions

WHERE

tx_count > 1;