count(DISTINCT a.block_timestamp::date) as "Active Days",

count(DISTINCT origin_from_address) as "Users",

count(DISTINCT a.tx_hash) as "Transactions",

"Users"/"Transactions" as "Avg Transaction Per User",

sum(tx_fee) as "Fee (Sei)",

avg(tx_fee) as "Avg Fee (Sei)",

median(tx_fee) as "Median Fee (Sei)",

max(tx_fee) as "Max Fee (Sei)"

from sei.core_evm.fact_event_logs a join sei.core_evm.fact_transactions b on a.tx_hash = b.tx_hash

where a.block_timestamp::date >= '2024-05-27'

group by 1

order by 3 desc