avg(datediff(second,a.block_timestamp, b.block_timestamp)) as avg_time

from monad.testnet.fact_blocks a, monad.testnet.fact_blocks b

where a.BLOCK_NUMBER = b.BLOCK_NUMBER-1

group by 1)

select trunc(date,'month') as month,

month_name,

avg(avg_time) as "Avg Time"

from base a join crosschain.core.dim_dates b on a.date = b.date_day

group by 1,2

order by 1 asc