select

count (distinct TX_ID) as Transaction ,

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,

sum(FEE) as fee ,

avg (fee) as Average_Fee,

median (fee) as Median_Fee,

min (fee) as Minimum_Fee,

max (fee) as Maximum_Fee

from terra.core.fact_transactions