fact_event_logs.origin_from_address,

COUNT(DISTINCT fact_event_logs.contract_address) AS distinct_contract_count,

SUM(fact_transactions.tx_fee) AS total_tx_fee,

COUNT(DISTINCT fact_event_logs.tx_hash) AS distinct_tx_count

FROM

sei.core_evm.fact_event_logs

JOIN

sei.core_evm.fact_transactions AS fact_transactions

ON

fact_event_logs.tx_hash = fact_transactions.tx_hash

GROUP BY

fact_event_logs.origin_from_address

ORDER BY

distinct_contract_count DESC

LIMIT 10;