date_trunc('month',block_timestamp) as date,

count (distinct proposer) as Users,

count (distinct tx_id) as Txs,

(Txs / Users) as Txs_Ratio

from flow.core.fact_transactions

where date >= '2022-06-01'

group by 1,2

union all

select 'Ethereum' as Net,

date_trunc('month',block_timestamp) as date,

count (distinct from_address) as Users,

count (distinct tx_hash) as Txs,

(Txs / Users) as Txs_Ratio

from ethereum.core.fact_transactions

where date >= '2022-06-01'

group by 1,2

union all

select 'Polygon' as Net,

date_trunc('month',block_timestamp) as date,

count (distinct from_address) as Users,

count (distinct tx_hash) as Txs,

(Txs / Users) as Txs_Ratio

from polygon.core.fact_transactions

where date >= '2022-06-01'

group by 1,2

union all

select 'Algorand' as Net,

date_trunc('month',block_timestamp) as date,

count (distinct tx_sender) as Users,