-- forked from Mrfti / Top addresses @ https://flipsidecrypto.xyz/Mrfti/q/-UBPsQRKzSWM/top-addresses
SELECT
from_address as "0xb47756093c1f81f51c6b74CEE53E97b2422E06C4",
count (DISTINCT tx_hash) as "Total tx"
from berachain.testnet.fact_transactions
GROUP by 1
order by 2 DESC
limit 100