with polygon1 as (select BLOCK_NUMBER, datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as diff from polygon.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') ,polygon as ( select min(diff) as min_Time ,max(diff) as max_Time, avg(diff) as avg_Time from polygon1) ,solana1 as (select BLOCK_ID, datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as diff from solana.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') ,solana as ( select min(diff) as min_Time ,max(diff) as max_Time, avg(diff) as avg_Time from solana1) ,flow1 as (select ID, datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as diff from flow.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') ,flow as (select min(diff) as min_Time ,max(diff) as max_Time, avg(diff) as avg_Time from flow1) ,arbitrum1 as (select BLOCK_NUMBER, datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as diff from arbitrum.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') ,arbitrum as (select min(diff) as min_Time ,max(diff) as max_Time, avg(diff) as avg_Time from arbitrum1) ,optimism1 as (select BLOCK_NUMBER, datediff(second,lag(BLOCK_TIMESTAMP,1) over( order by BLOCK_TIMESTAMP),BLOCK_TIMESTAMP) as diff from optimism.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') ,optimism as (select min(diff) as min_Time ,max(diff) as max_Time, avg(diff) as avg_Time from optimism1) select 'Polygon' as Name , *, (select round(avg(tx_count),0) from polygon.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') as avg_txs from polygon union all select 'Solana' as Name , * , (select round(avg(tx_count),0) from solana.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') as num_avg_txs from solana union all select 'Flow' as Name , * , (select round(avg(tx_count),0) from flow.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') as num_avg_txs from flow union all select 'Arbitrum' as Name , * , (select round(avg(tx_count),0) from arbitrum.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') as num_avg_txs from arbitrum union all select 'Optimism' as Name , * , (select round(avg(tx_count),0) from optimism.core.fact_blocks where BLOCK_TIMESTAMP::date<='2022-07-25') as num_avg_txs from optimism

Query	Creator	Created
near cl3 near solana staking	DataWhizLady	Nov 8, 2022
Sol9 solana	DataWhizLady	Oct 7, 2022
near cl2 near solana staking	DataWhizLady	Nov 8, 2022
Solana-open7-usdc solana	DataWhizLady	Nov 24, 2022
Solana-open9-usdt solana	DataWhizLady	Nov 24, 2022
Polygon Block Performance-compare L1 vs L2 flow arbitrum optimism polygon solana	DataWhizLady	Jul 24, 2022

DataWhizLady