sum(tx_count)/count(block_id) as algorand

from algorand.core.fact_block

group by 1

),

Near as (select date_trunc('day',block_timestamp) as date,

sum(tx_count)/count(block_id) as near

from near.core.fact_blocks where date >= '2022-01-01'

group by 1

),

flow as(select date_trunc('day',block_timestamp) as date,

sum(tx_count)/count(BLOCK_HEIGHT) as flow

from flow.core.fact_blocks where date >= '2022-01-01'

group by 1

),

Ethereum as(

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

sum(tx_count)/count(block_number) as ethereum

from ethereum.core.fact_blocks where date >= '2022-01-01'

group by 1

)

select Algorand.date,

algorand,

flow,

near,

ethereum

from Algorand join Near on Algorand.date=Near.date

join flow on Algorand.date= flow.date

join Ethereum on Algorand.date= Ethereum.date