with lst_all_polygon as ( select BLOCK_NUMBER ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from polygon.core.fact_blocks ) ,dist_poly as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_polygon where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) , lst_all_sol as ( select BLOCK_ID ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from solana.core.fact_blocks ) ,dist_sol as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_sol where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) , lst_all_eth as ( select BLOCK_NUMBER ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from ethereum.core.fact_blocks ) ,dist_eth as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_eth where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) , lst_all_flow as ( select BLOCK_HEIGHT ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from flow.core.fact_blocks ) ,dist_flow as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_flow where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) , lst_all_arbitrum as ( select BLOCK_NUMBER ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from arbitrum.core.fact_blocks ) ,dist_arbitrum as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_arbitrum where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) , lst_all_osmosis as ( select BLOCK_ID ,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP) as date_lag ,datediff(second,date_lag,BLOCK_TIMESTAMP) as date_diff_block from osmosis.core.fact_blocks ) ,dist_osmosis as ( select case when DATE_DIFF_BLOCK >=0 and DATE_DIFF_BLOCK<=3 then '0 Sec To 3 Sec' when DATE_DIFF_BLOCK >3 and DATE_DIFF_BLOCK<=5 then '4 Sec To 5 Sec' when DATE_DIFF_BLOCK >5 and DATE_DIFF_BLOCK<=10 then '6 Sec To 10 Sec' when DATE_DIFF_BLOCK >10 and DATE_DIFF_BLOCK<=30 then '11 Sec To 30 Sec' when DATE_DIFF_BLOCK >30 then 'More than 31 seconds' end as Distribution ,count(DATE_DIFF_BLOCK) as block_counts from lst_all_osmosis where DATE_DIFF_BLOCK>0 group by 1 order by 1 ) ,lst_all as ( select 'polygon' as type ,* from dist_poly union all select 'solana' as type ,* from dist_sol union all select 'ethereum' as type ,* from dist_eth union all select 'flow' as type ,* from dist_flow union all select 'arbitrum' as type ,* from dist_arbitrum union all select 'osmosis' as type ,* from dist_osmosis ) select * from lst_all order by TYPE

Polygon Block Performance