a.tx_hash,

a.origin_from_address,

tx_fee,

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

)

select contract_address,

count(DISTINCT origin_from_address) as "Users",

count(DISTINCT tx_hash) as "Transactions",

sum(tx_fee) as "Total Fees (Sei)",

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

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

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

from contract

group by 1

order by 2 desc