when block_number < 15537351 then 'Before Merge'

when block_number >= 15537351 then 'After Merge'

end as merge,

count (distinct tx_hash) as txn,

count (distinct from_address) as users,

sum (gas_used) as gas_used,

avg (gas_used) as avg_gas,

sum (tx_fee) as total_fee,

avg (tx_fee) as avg_fee

from ethereum.core.fact_transactions

where status = 'SUCCESS'

and block_timestamp::date between'2022-09-01' and '2022-09-30'

group by 1