date_trunc('{{granularity}}', BLOCK_TIMESTAMP) as date,

'Mezo' as blockchain,

count(BLOCK_NUMBER) as n_blocks,

count(DISTINCT tx_hash) as n_transaction,

count(DISTINCT case when TX_SUCCEEDED = 'TRUE' then tx_hash end) as TRANSACTION_COUNT_SUCCESS_,

count(DISTINCT case when TX_SUCCEEDED = 'FALSE' then tx_hash end) as TRANSACTION_COUNT_FAILED_,

TRANSACTION_COUNT_SUCCESS_ / (coalesce(TRANSACTION_COUNT_SUCCESS_,0) + coalesce(TRANSACTION_COUNT_FAILED_,0)) as success_rate

from mezo.testnet.fact_transactions

where date > '2025-03-28'

group by 1 , 2

order by date desc

-- 2025-03-28