SELECT

TIMESTAMPDIFF(SECOND, MIN(block_timestamp), MAX(block_timestamp)) / (COUNT(DISTINCT(block_timestamp)) - 1) as avgtime,

AVG(tx_count) as avgtx

FROM polygon.core.fact_blocks, ethereum.core.fact_blocks

),

timetablepolygon AS (

SELECT

a.block_number as blocka,

b.block_number as blockb,

a.block_timestamp as timea,

b.block_timestamp as timeb,

TIMESTAMPDIFF(SECOND, b.block_timestamp, a.block_timestamp) as difference

FROM polygon.core.fact_blocks a

JOIN polygon.core.fact_blocks b

ON a.block_number = b.block_number + 1

),

minmaxpolygon AS(

SELECT

MIN(difference),

MAX(difference)

FROM timetablepolygon

),

performance AS (

SELECT *

FROM avgtimepolygon, minmaxpolygon

SELECT *

FROM performance