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