tx_type,

COUNT(*) AS total_transactions,

COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END) AS successful_transactions,

COUNT(CASE WHEN tx_succeeded = FALSE THEN 1 END) AS failed_transactions,

ROUND((COUNT(CASE WHEN tx_succeeded = TRUE THEN 1 END) * 100.0 / COUNT(*)), 2) AS success_rate,

ROUND((COUNT(CASE WHEN tx_succeeded = FALSE THEN 1 END) * 100.0 / COUNT(*)), 2) AS failure_rate

FROM ALEO.core.fact_transactions

GROUP BY tx_type

ORDER BY total_transactions DESC;