with list as (select a.block_number,
b.block_timestamp,
count(a.tx_hash) over (partition by a.block_number) as block_count
from arbitrum.core.fact_transactions a
join arbitrum.core.fact_blocks b
on a.block_number = b.block_number
where a.block_timestamp::date >='2022-07-15'
and a.block_timestamp = b.block_timestamp
)
select round(avg(block_count),3) as "average block transactions "
, round(max(block_count),3) as "max block transactions"
, round(min(block_count),3) as "min block transactions"
from list