select

BLOCK_NUMBER as BLOCK_NUMBER,

count(distinct TX_HASH) as transations

from ethereum.core.fact_transactions

GROUP BY 1)

select

'ethereum' as network,

avg(transations) as avg_tx,

min(transations) as min_tx,

max(transations) as max_tx

from ethereum