CASE WHEN SUCCESSFUL THEN 'Successful' ELSE 'Failed' END AS TYPE,

COUNT(DISTINCT transaction_hash) AS txs

stellar.core.fact_transactions

GROUP BY

1