SELECT

TX_FROM,

COUNT(TX_ID) AS user_transaction_count

FROM

axelar.core.fact_transactions

WHERE

BLOCK_TIMESTAMP >= CURRENT_DATE - INTERVAL '30 DAYS'

GROUP BY

TX_FROM

SELECT

AVG(user_transaction_count) AS avg_transactions_per_user

FROM

UserTransactionCounts;