freemartianTotal Top Realms In The Number Of Proposals
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
›
⌄
select distinct PROGRAM_NAME, address_name, realms_id, count (distinct voter) as member_Count,
case
when realms_id in ('78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh', 'ATnhhZJ74xg4mzxDyNQ5YAE1BZ98PhrhAsMS4xNXquvX') then 'Jet DAO'
when realms_id in ('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', 'EJw396bhCYaQUmcUQ6SHAgCWBXjxxLG1VBDxDi7mhU6q') then 'Mango DAO'
when realms_id in ('2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817') then 'MetaPlex DAO'
when realms_id in ('FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', '83FAo555RKkvuNmPhwJoqo9udvp4DKTj7jBYiMWZLFey') then 'PSY DAO'
when realms_id in ('3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg', '5pNokKBsf5EaAVrFbKPuhoYiCu7awsiGsmYqnKwpjvxr') then 'Serum DAO'
when realms_id in ('7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn', '6gcJCdWmWe2JuMX7Tyhs3gQD5pgxRZcF4kz8LTKMMTH9') then 'Solend DAO'
when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDao'
when realms_id = '66Du7mXgS2KMQBUk6m9h3TszMjqZqdWhsG3Duuf69VNW' then 'Orca DAO'
when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape DAO'
when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'Imperium Of Rain DAO'
when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify DAO'
else 'Others'
end as DAOs
from solana.core.fact_proposal_votes v
inner join solana.core.dim_labels l on l.address = v.PROGRAM_NAME
group by PROGRAM_NAME, address_name, realms_id, DAOs
order by member_count DESC
limit 10
Run a query to Download Data