count(tx_hash) AS "Number of Transactions",

SUM(tx_fee) AS "Total Fee",

AVG(tx_fee) AS "Average Fee",

(CASE

WHEN block_timestamp < '2023-06-06 16:00:00.000' THEN 'Old System'

ELSE 'Bedrock System' END

) AS "Period"

FROM optimism.core.fact_transactions

WHERE block_timestamp::date >= current_date - 20

GROUP BY 1, "Period"

ORDER BY 1