from berachain.testnet.fact_transactions

where from_address = '0x06cb8cfbd729888168ce2552da91b97c76c983c5'

and to_address = '0x9faa90d6797bd01db2035f820fa662e38ccbaaab')

select

count(DISTINCT a.tx_hash) as total_tx,

count(DISTINCT to_address) as users,

sum(VALUE_PRECISE) as "Bera Amount",

avg(VALUE_PRECISE) as "Avg Bera Amount"

from berachain.testnet.fact_traces a join vault b on a.tx_hash = b.tx_hash

where FROM_ADDRESS = '0x9faa90d6797bd01db2035f820fa662e38ccbaaab'

and to_address != '0x9faa90d6797bd01db2035f820fa662e38ccbaaab'

and from_address != '0x06cb8cfbd729888168ce2552da91b97c76c983c5'