from polygon.core.fact_blocks)

,pol as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_pol

)

-----------------------------------------------------------------------------------------------------------------------------------

, records_sol as (select BLOCK_ID,datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as distance

from solana.core.fact_blocks)

,sol as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_sol

)

-----------------------------------------------------------------------------------------------------------------------------------

, records_flow as (select ID,datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as distance

from flow.core.fact_blocks)

,flow as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_flow

)

-----------------------------------------------------------------------------------------------------------------------------------

, records_arb as (select BLOCK_NUMBER,datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as distance

from arbitrum.core.fact_blocks)

,arb as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_arb

)

-----------------------------------------------------------------------------------------------------------------------------------

, records_opti as (select BLOCK_NUMBER,datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as distance

from optimism.core.fact_blocks)

,opti as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_opti

)

-----------------------------------------------------------------------------------------------------------------------------------

, records_algo as (select BLOCK_ID,datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as distance

from flipside_prod_db.algorand.block)

,algo as (

select min(distance) as minTime ,max(distance) as maxTime,avg(distance) as avgTime from records_algo

)

select 'Polygon' as detect , *,