SELECT

DISTINCT tx_hash

FROM

ethereum.core.ez_decoded_event_logs

WHERE

contract_address = LOWER('0xfae103dc9cf190ed75350761e95403b7b8afa6c0')

AND event_name = 'Transfer'

AND decoded_log:from = '0x0000000000000000000000000000000000000000'

),

transaction_fees AS (

SELECT

DISTINCT tx_hash,

tx_fee

FROM

ethereum.core.fact_transactions

SUM(transaction_fees.tx_fee) AS total_tx_fee,

AVG(transaction_fees.tx_fee) AS avg_tx_fee

base

JOIN transaction_fees ON base.tx_hash = transaction_fees.tx_hash;