count(distinct from_address) as n_unique_eoas,

sum(case when nonce = 0 then 1 else 0 end) as new_user,

sum(case when tx_succeeded = FALSE then 1 else 0 end) as failed_tx,

count(tx_hash) as n_tx,

DIV0(failed_tx, n_tx) as fail_tx_percent,

sum(value) as "Raw Bera Volume",

sum(tx_fee) as "Total Tx Fees"

from berachain.testnet.fact_transactions

group by day_