-- Identify the top 10 addresses by delegated voting power.
-- Bonus: Identify whether these are individuals or syndicates
select voter, voting_power_billion from (
select
voter,
voting_power/pow(10,9) as voting_power_billion,
rank() over (partition BY voter ORDER BY block_timestamp DESC ) AS rank
from aave.votes
)
where rank = 1 -- Get the Latest voting power for each voter.
order by voting_power_billion desc
limit 10