SELECT DATEDIFF(second, LAG(block_timestamp) OVER(ORDER BY block_number), block_timestamp) AS time_blocks

, tx_count

FROM polygon.core.fact_blocks

),

polygon AS (

SELECT AVG(time_blocks) AS "Avg. Time"

, MIN(time_blocks) AS "Min Time"

, MAX(time_blocks) AS "Max Time"

, AVG(tx_count) AS "Avg. Tx"

, MIN(tx_count) AS "Min Tx"

, MAX(tx_count) AS "Max Tx"

, "Avg. Tx"/"Avg. Time" AS "Tx Sec"

, 'Polygon' AS blockchain

FROM polygon_block_data

),

flow_block_data AS (

SELECT DATEDIFF(second, LAG(block_timestamp) OVER(ORDER BY block_height), block_timestamp) AS time_blocks

, tx_count

FROM flow.core.fact_blocks

),

flow AS (

SELECT AVG(time_blocks) AS "Avg. Time"

, MIN(time_blocks) AS "Min Time"

, MAX(time_blocks) AS "Max Time"

, AVG(tx_count) AS "Avg. Tx"

, MIN(tx_count) AS "Min Tx"

, MAX(tx_count) AS "Max Tx"

, "Avg. Tx"/"Avg. Time" AS "Tx Sec"

, 'Flow' AS blockchain

FROM flow_block_data

),

sol_block_data AS (

SELECT DATEDIFF(second, LAG(block_timestamp) OVER(ORDER BY block_height), block_timestamp) AS time_blocks

, tx_count

FROM solana.core.fact_blocks