with delegatees AS (

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

SELECT

date_trunc('day', block_timestamp::date) AS time,

count(tx_hash) AS Vote_count,

count(DISTINCT voter) AS Voter_Count,

count(DISTINCT proposal_id) AS Participated_proposals,

sum(voting_power)/pow(10,18) AS voting_powerr,

sum(Vote_count) over (ORDER BY time) AS cumulative_vote_count,

sum(voting_powerr) over (ORDER BY time) AS cumulative_voting_power

FROM ethereum.aave.ez_votes

WHERE voter NOT IN (SELECT delegatee FROM delegatees)

AND block_timestamp > current_date - 180

GROUP BY time