round((Sum(success) / (Sum(success) + Sum(failed))),2) * 100 AS success_percent,

Count(DISTINCT from_address) AS no_of_users,

round(Sum(tx_fee) ,2) AS txn_fees

FROM (SELECT *,

Iff(status = 'SUCCESS', '1', '0') AS success,

Iff(status = 'FALSE', '0', '1') AS failed

FROM gnosis.core.fact_transactions)