event_name,

sum(gas_price) as total_gas_price,

sum(gas_used) as total_gas_used,

sum(tx_fee) as total_tx_fee,

avg(tx_fee) as average_tx_fee

from ethereum.core.fact_event_logs

join ethereum.core.fact_transactions a

using(tx_hash)

where contract_address = '0x92d6c1e31e14520e676a687f0a93788b716beff5'

and a.block_timestamp > current_date - 90

and event_name is not null

group by event_name