count(distinct(tx_id)) as number_of_all_transactions

from flow.core.fact_transactions

where block_timestamp >'2023-06-08'

group by 1),

flow_2 as (select date_trunc( 'day',block_timestamp) as day,

count(distinct(tx_id)) as number_of_succeeded_transactions

from flow.core.fact_transactions

where block_timestamp >'2023-06-08' and tx_succeeded = 'TRUE'

group by 1),

flow_summary as

(select 'FLOW' as type, flow_1.day, number_of_all_transactions, number_of_succeeded_transactions,

number_of_succeeded_transactions*100/number_of_all_transactions as success_ratio

from flow_1,flow_2 where flow_2.day = flow_1.day),

sol_1 as (select date_trunc( 'day',block_timestamp) as day,

count(distinct(tx_id)) as number_of_all_transactions

from solana.core.fact_transactions

where block_timestamp >'2023-06-08'

group by 1),

sol_2 as (select date_trunc( 'day',block_timestamp) as day,

count(distinct(tx_id)) as number_of_succeeded_transactions

from solana.core.fact_transactions

where block_timestamp >'2023-06-08'

and succeeded = 'TRUE'

group by 1),

sol_summary as

(select 'Solana' as type, sol_1.day, number_of_all_transactions, number_of_succeeded_transactions,

number_of_succeeded_transactions*100/number_of_all_transactions as success_ratio

from sol_1,sol_2 where sol_1.day = sol_2.day),

eth_1 as (select date_trunc( 'day',block_timestamp) as day, count(distinct(origin_from_address)) as eth_wallets_count,

count(distinct(tx_hash)) as number_of_all_transactions

from ethereum.core.fact_event_logs

where block_timestamp >'2023-06-08'

group by 1),

eth_2 as (select date_trunc( 'day',block_timestamp) as day, count(distinct(origin_from_address)) as eth_wallets_count,

count(distinct(tx_hash)) as number_of_succeeded_transactions