case

when BLOCK_NUMBER < 15537393 then 'Before_Merge'

when BLOCK_NUMBER >= 15537393 then 'After_Merge'

end as category,

(sum(tx_fee)/ COUNT(DISTINCT TX_HASH)) as "fee per tx",

(sum(GAS_USED)/ COUNT(DISTINCT TX_HASH)) as "gas used per tx",

COUNT(DISTINCT TX_HASH) as "total txn",

sum(ETH_VALUE) as "transactions amount in ETH"

FROM ethereum.core.fact_transactions

WHERE block_timestamp >= CURRENT_DATE - 28

group by category