select block_number

, tx_count

, gas_used

, gas_limit

from avalanche.core.fact_blocks

where block_number > 16462629

and block_number <= 16511800

and blockchain = 'avalanche'

order by block_number asc

),

tx as (

select block_number

, avg(gas_price) as avg_tx_gas_price

, avg(tx_fee) as avg_tx_fee

, avg(gas_used) as avg_tx_gas_used

, avg(gas_limit) as avg_tx_gas_limit

from avalanche.core.fact_transactions

where block_number > 16462629

and block_number <= 16511800

group by 1

order by block_number asc

)

select block.*

, tx.*

from block

join tx on block.block_number = tx.block_number

order by block.block_number asc