AS (SELECT block_timestamp AS blk_time,

block_number AS block_no

FROM optimism.core.fact_blocks)

SELECT Date(block_timestamp) AS day,

Avg(time_diff) AS avg_time_taken,

Avg(avg_time_taken)

OVER (

ORDER BY day) AS avg_time_taken_over_time

FROM (SELECT *,

Timestampdiff(sql_tsi_second, blk_time, block_timestamp) AS

time_diff

FROM opt_blocks

INNER JOIN optimism.core.fact_blocks

ON block_number = block_no + 1)

WHERE day >= '2022-06-15'

GROUP BY day

ORDER BY day DESC