count (distinct tx_id) as Transactions,

count (Distinct tx_from) as users,

sum (fee/1e6) as Fees,

transactions / users as TX_Per_User,

fees / users as Fee_Per_user,

avg (fee/1e6) as Average_Fees,

sum (transactions) over (order by date) as Cumulative_Transactions,

sum (fees) over (order by date) as Cumulative_Fees,

count (case when TX_Succeeded != 'TRUE' then 1 end) as Failed_TX,

count (case when TX_Succeeded = 'TRUE' then 1 end) as Success_TX,

(Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate

from lava.core.fact_transactions

where block_timestamp >= '2024-07-30 11:00:00.000' -- Public Mainnet Launch

group by 1

order by 1 desc