case when realms_id='A7nud4wxpAySc7Ai11vwXtkez79tHvcEvSquFBxw4iDh' then 'allovr'

when realms_id='FuqmCzaTqH1QbokY3agcYQaJqoWog1UkSrcNCDBPXusu' then 'chicken tribe'

when realms_id='78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'jet'

when realms_id='ATnhhZJ74xg4mzxDyNQ5YAE1BZ98PhrhAsMS4xNXquvX' then 'jet'

when realms_id='FbpwgUzRPTneoZHDMNnM1zXb7Jm9iY8MzX2mAM8L6f43' then 'jet'

when realms_id='EJw396bhCYaQUmcUQ6SHAgCWBXjxxLG1VBDxDi7mhU6q' then 'mango'

when realms_id='DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'mango'

when realms_id='Eb69t8zTkNbBViLRykbgBofr8PbwvZoAX4KicVcNNwkj' then 'mango'

when realms_id='DnWHRVRbA2XGwWth2da7iF3Q81cqRHhqJXSPS8J3G6fo' then 'mango'

when realms_id='2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'metaplex'

when realms_id='Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'metaplex '

when realms_id='FbpwgUzRPTneoZHDMNnM1zXb7Jm9iY8MzX2mAM8L6f43' then 'jet'

when realms_id='B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'monkedao'

when realms_id='Hcenib1A54LtG4V3TkG4MFYzcLzTqzYKFnttMxAq55c2' then 'monkedao'

when realms_id='66Du7mXgS2KMQBUk6m9h3TszMjqZqdWhsG3Duuf69VNW' then 'orca'

when realms_id='4BNkheiMATVVcyJnGpjPbbPvFuKMx3cCDmkEbtnTz2iV' then 'phantasia'

when realms_id='83FAo555RKkvuNmPhwJoqo9udvp4DKTj7jBYiMWZLFey' then 'psy finance'

when realms_id='FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'psy finance'

when realms_id='8HZ4V94dtojrTpdUpWrfstr7bEhRnZZHn8jotfns9L9x' then 'ratio finance'

when realms_id='5J2bRTkzoSXWKZMW4o5tyNsT7Zwn9dDkDt6rMz6Ze9u1' then 'renpō dao'

when realms_id='3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'serum'

when realms_id='5pNokKBsf5EaAVrFbKPuhoYiCu7awsiGsmYqnKwpjvxr' then 'serum'

when realms_id='759qyfKDMMuo9v36tW7fbGanL63mZFPNbhU7zjPrkuGK' then 'socean'

when realms_id='6gcJCdWmWe2JuMX7Tyhs3gQD5pgxRZcF4kz8LTKMMTH9' then 'solend'

when realms_id='7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'solend'

when realms_id='5EuXAPZCpzZnqpzVRX5Ytizh9BFVtbz3H8Xk9H5onxHD' then 'solend'

when realms_id='5piGF94RbCqaogoFFWA9cYmt29qUpQejGCEjRKuwCz7d' then 'ukraine'

when realms_id='By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'grape'

when realms_id='A9zS9kTuobH3nSyzvhtVqhRA61vXs2wnxrQgMScUBzur' then 'grape'

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

when realms_id='7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'

when realms_id ='GBXLYo4ycRNfzuzYeudu6y2ng4afNeW14WcpM2E4JJSL' then 'UXD Protocl'

else realms_id end AS Dao,

count(*) as votes

FROM solana.core.fact_proposal_votes