AVG(total_transactions) as average_txs

(

SELECT

sender as wallet,

COUNT(DISTINCT tx_hash) as total_transactions

FROM

aptos.core.fact_transactions

where

success = TRUE

AND wallet != ''

GROUP BY

wallet

)