COUNT(tx_hash) AS "Number of Transactions",

SUM(tx_fee) AS "Total Fee",

AVG(tx_fee) AS "Average Fee",

AVG(tx_fee) * COUNT(tx_hash) AS "aaaaa",

(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 BETWEEN '{{start_date}}' AND '{{end_date}}'

GROUP BY 1, "Period"

ORDER BY 1