select

case when succeeded = 'True' then 'Success' else 'Failed' end as transaction_status,

count(distinct tx_id) as transaction_count,

count(distinct signers[0]) as unique_users,

sum(fee/1e9) as total_fees

from

eclipse.core.fact_transactions

group by

transaction_status

transaction_status,

transaction_count,

unique_users,

round(total_fees, 4) as total_fees,

round(transaction_count * 100.0 / sum(transaction_count) over (), 2) as transaction_percentage,

round(unique_users * 100.0 / sum(unique_users) over (), 2) as users_percentage,

round(total_fees * 100.0 / sum(total_fees) over (), 2) as fees_percentage

transaction_summary

order by

transaction_count desc