select

count(distinct y.tx_hash) as n_votes,

count(distinct voter) as voters,

sum(tx_fee) as eth_fees ,

avg(tx_fee) as avg_eth_fees ,

sum(gas_used/1e9) as gas_spent,

avg(gas_used/1e9) as avg_gas_spent

from ethereum.core.fact_transactions x

join ethereum.aave.ez_votes y on x.tx_hash=y.tx_hash

where y.block_timestamp >= CURRENT_DATE - 180