select DISTINCT CONCAT(SUBSTR(from_address, 1, 6), '...', SUBSTR(from_address, -4)) as "User",
count(DISTINCT tx_hash) as "Transactions",
sum(tx_fee_precise) as "Paid Fees $BERA",
count(DISTINCT block_timestamp::date) as "Active Days",
count(DISTINCT contract_address) as "Contracts"
from berachain.testnet.fact_transactions
where block_timestamp::date >= '2024-06-01'
and tx_succeeded
group by 1
order by 2 DESC
limit 1000