SELECT

block_number,

block_timestamp::date AS block_date,

DATEDIFF('second', LAG(block_timestamp) OVER (ORDER BY block_number), block_timestamp) AS seconds_between_blocks

FROM

flow.core_evm.fact_blocks

),

non_evm_blocks AS (

SELECT

block_height,

block_timestamp::date AS block_date,

DATEDIFF('second', LAG(block_timestamp) OVER (ORDER BY block_height), block_timestamp) AS seconds_between_blocks

FROM

flow.core.fact_blocks

select 'EVM' as net,block_date, avg(seconds_between_blocks) as avg_seconds_between_blocks from evm_blocks group by 1,2

UNION select 'Mainnet' as net, block_date, avg(seconds_between_blocks) as avg_seconds_between_blocks from non_evm_blocks group by 1,2