select block_timestamp::date as "Day", avg(tx_count) as "TX per Block"

from avalanche.core.fact_blocks

where block_timestamp::date < current_date

group by 1

),

avg_info as (

select avg("TX per Block") "Average TX in Block"

from info

select *

from info, avg_info