CASE WHEN tx_succeeded = true THEN 'Succeeded'

ELSE 'Failed'

END AS status,

COUNT(distinct tx_id) as Count

FROM evmos.core.fact_transactions

WHERE tx_succeeded = true

GROUP BY 1, 2;