WITH tab1 as (
SELECT
BLOCK_NUMBER,
count(*) as amt
FROM optimism.core.fact_transactions
GROUP BY 1
)
SELECT
date_trunc('day', block_timestamp),
avg(amt) as avg,
min(amt) as min,
max(amt) as max
FROM optimism.core.fact_blocks JOIN tab1 on tab1.BLOCK_NUMBER= optimism.core.fact_blocks.BLOCK_NUMBER
GROUP BY 1