decoded_log:delegatee AS Delegatee,

count(distinct decoded_log:delegator) AS delegated_wallets

FROM ethereum.core.fact_decoded_event_logs

WHERE contract_address = '0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9'

AND event_name in ('DelegateChanged')

GROUP BY delegatee

HAVING delegated_wallets > 2

),

delegate_votes AS (

SELECT

tx_hash,

block_timestamp

FROM ethereum.aave.ez_votes

WHERE voter IN (SELECT delegatee FROM delegatees)

AND block_timestamp > current_date - 180

),

regular_votes AS(

SELECT

tx_hash,

block_timestamp

FROM ethereum.aave.ez_votes

WHERE voter NOT IN (SELECT delegatee FROM delegatees)

AND block_timestamp > current_date - 180

SELECT

'Regular Users' AS Voter_Type,

sum(tx_fee) AS Fee,

avg(tx_fee) AS Average_Fee,

sum(gas_used)/pow(10,9) AS Gas,

avg(gas_used)/pow(10,9) AS Average_Gas,