SELECT

from_address AS address,

COUNT(tx_hash) AS txs

FROM

berachain.testnet.fact_transactions

WHERE

tx_succeeded = 'TRUE'

GROUP BY

from_address

SELECT

b.current_bal AS eth_mainnet_bal,

b.user_address

FROM

tbl t

JOIN

ethereum.core.ez_current_balances b

ON

t.address = b.user_address

ORDER BY

eth_mainnet_bal DESC

LIMIT 100;