vendettaTop 5 realms proposals by votes
Updated 2022-08-31
99
1
2
3
4
5
6
7
8
9
10
11
12
›
⌄
select case when proposal ='9aLYCv1sazi2uvv1GAEHS68hx4JWrmMSd7ywCivT7cmj' then 'Fourth Time a Charm'
when proposal ='ARo5QFL5FmXipRGdxxhQHLsDUgdNERujFniDy2HEJjqw' then 'Lets try this again bois'
when proposal ='9oKujEq3ypdN7Fyv1oFbFye4haGAAfVdcboL9SdvexK2' then 'Bug Bounty Program'
when proposal ='YkQwTTYEvjrzb1Lrn9KoMzrEpsmEHbRqE3hxP6SE5eK' then 'Test Grant'
when proposal ='Gmj5uhmECnQmwbrC68736PNyuMpiUf2XyMV3LYbeoXQf' then 'Intergalactic Monkey Space Odyssey - $RAIN adoption - Updated Proposal' else proposal end as proposal_name
,count (distinct tx_id) as Votes,
count (distinct voter) as Voters
from solana.core.fact_proposal_votes
where governance_platform = 'realms'
group by 1
order by 2 DESC
limit 5
Run a query to Download Data