t.from_address AS user,

t.tx_hash,

l.contract_address,

l.contract_name

avalanche.core.fact_transactions t

avalanche.core.ez_decoded_event_logs l ON t.tx_hash = l.tx_hash

t.block_timestamp >= DATEADD('day', -90, CURRENT_DATE())

AND l.contract_address IS NOT NULL

COALESCE(INITCAP(contract_name), contract_address) AS "Contract Name",

COUNT(DISTINCT user) AS "Total Unique Users"

TransactionData_Last90Days

GROUP BY

1, contract_address, contract_name

ORDER BY

"Total Unique Users" DESC

LIMIT 10 ;