select

LAG(block_timestamp) over(order by block_timestamp) as previous_block_time,

block_timestamp as block_time,

tx_count

from polygon.core.fact_blocks

),

polygon_blocks as (

select

datediff('second', previous_block_time, block_time) as diff,

tx_count

from polygon

),

polygon_performance as (

select 'Polygon' as Blockchain,

max(diff) as max_time,

min(diff) as min_time,

avg(diff) as average_time,

avg(tx_count) as avg_N_transactions

from polygon_blocks

),

flow as (

select

LAG(block_timestamp) over(order by block_timestamp) as previous_block_time,

block_timestamp as block_time,

tx_count

from flow.core.fact_blocks

),

flow_blocks as (

select

datediff('second', previous_block_time, block_time) as diff,

tx_count

from flow

),

flow_performance as (

select 'Flow' as Blockchain,