select year, count(block_number), min(n_txn) as min_txn, max(n_txn) as max_txn, avg(n_txn) as avg_txn,
min(gas_used) as min_gas, max(gas_used) as max_gas, avg(gas_used) as avg_gas
from (select date_trunc('year',block_timestamp) as year, block_number, count(tx_hash) as n_txn, sum(gas_used) as gas_used
from ethereum.core.fact_transactions
group by 1,2 order by 1)
group by 1