(SUM(CASE WHEN tx_succeeded = TRUE THEN 1 ELSE 0 END) * 100.0 / COUNT(tx_id)) AS success_rate_percentage

lava.core.fact_transactions

block_timestamp >= '2024-07-01' AND block_timestamp < '2024-08-01';