date_trunc (day,block_timestamp) as date,

count (case when tx_status not ilike 'success' then 1 end) as Failed_TX,

count (case when tx_status ilike 'success' then 1 end) as Success_TX,

(Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate

from near.core.fact_transactions

where block_timestamp >= '2022-11-07' and block_timestamp < '2022-11-15'

group by 1,2

union ALL

select 'FLOW' as chain,

date_trunc (day,block_timestamp) as date,

count (case when tx_succeeded != 'TRUE' then 1 end) as Failed_TX,

count (case when tx_succeeded = 'TRUE' then 1 end) as Success_TX,

(Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate

from flow.core.fact_transactions

where block_timestamp >= '2022-11-07' and block_timestamp < '2022-11-15'

group by 1,2

union ALL

select 'Solana' as chain,

date_trunc (day,block_timestamp) as date,

count (case when succeeded != 'TRUE' then 1 end) as Failed_TX,

count (case when succeeded = 'TRUE' then 1 end) as Success_TX,

(Success_TX / (Success_TX + Failed_TX)) * 100 as Success_Rate

from solana.core.fact_transactions

where block_timestamp >= '2022-11-07' and block_timestamp < '2022-11-15'

group by 1,2