COUNT(DISTINCT payer) AS total_wallets,

COUNT(tx_id) AS total_transactions,

COUNT(tx_id) / COUNT(DISTINCT payer) AS avg_transactions_per_wallet

FROM flow.core.fact_transactions;