count(distinct tx_id) as total_txs,

sum(iff(tx_succeeded = true, 1, 0)) / total_txs * 100 as success_rate,

case when success_rate > 85 then '>85%' else '<85%' end as type

from flow.core.fact_transactions

where fecha >= '2022-05-01'

group by 1

order by 1