SELECT COUNT(DISTINCT sender) AS tot_wallet

FROM aptos.core.fact_transactions

WHERE success = TRUE

),

total_transactions AS (

SELECT COUNT(DISTINCT tx_hash) AS tot_transaction

FROM aptos.core.fact_transactions

SELECT

tot_transaction/tot_wallet AS avg_tx_per_wallet

FROM total_wallet, total_transactions;