with tbl1 AS(

SELECT block_number, lag(block_timestamp,1) over (order by block_timestamp asc) as last_block_time , min(block_timestamp) AS block_time

FROM arbitrum.core.fact_transactions

where block_number IN

(

SELECT DISTINCT block_number

FROM arbitrum.core.fact_transactions

order by block_number

)

group by block_number, block_timestamp

)

SELECT

max(datediff(second, last_block_time, block_time)) as max_time

from tbl1

order by block_number