case when realms_id ='By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'

when realms_id ='GBXLYo4ycRNfzuzYeudu6y2ng4afNeW14WcpM2E4JJSL' then 'UXD Protocl'

when realms_id ='6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain'

when realms_id ='DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'

when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'

when realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet DAO'

when realms_id = '9LY3wA9g4nAG8RhgSMeVaDU8MNF261ZuUnJFDExaEn15' then 'DQ8VRfxtdfJop8'

when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend DAO'

when realms_id = '66Du7mXgS2KMQBUk6m9h3TszMjqZqdWhsG3Duuf69VNW' then 'Orca DAO'

when realms_id = '413KSeuFUBSWDzfjU9BBqBAWYKmoR8mncrhV84WcGNAk' then 'Tulip Protocol'

when realms_id = '' then ''

else realms_id end as dao,

count (distinct voter) as voters

from solana.core.fact_proposal_votes

where governance_platform = 'realms'

group by realms_id

order by voters desc

limit 9