Peimansucces rate of users
    Updated 2022-07-06
    select
    count(case when TX_STATUS = 'SUCCEEDED' then 1 end) as successes_transactions,
    count(case when TX_STATUS = 'FAILED' then 1 end) as Failed_transactions,
    (successes_transactions/(Failed_transactions+successes_transactions))*100 as "success rate of users %"
    from terra.transactions
    where block_timestamp >= current_date-60




    Run a query to Download Data