SELECT

*,

CASE WHEN realms_id LIKE 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' THEN 'Mango DAO'

WHEN realms_id LIKE 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' THEN 'Grape DAO'

WHEN realms_id LIKE 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' THEN 'Psy Finance DAO'

WHEN realms_id LIKE '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' THEN 'Solend DAO'

WHEN realms_id LIKE 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' THEN 'MonkeDAO'

WHEN realms_id LIKE '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' THEN 'Metaplex Foundation DAO'

WHEN realms_id LIKE '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' THEN 'Jet DAO'

WHEN realms_id LIKE '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' THEN 'Serum DAO'

WHEN realms_id LIKE '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' THEN 'The Imperium of Rain DAO'

WHEN realms_id LIKE '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' THEN 'Synthetify DAO' end as dao

--count(DISTINCT VOTER_ACCOUNT) as votter

--COUNT(DISTINCT voter_account)

FROM solana.core.fact_proposal_votes

WHERE GOVERNANCE_PLATFORM LIKE 'realms'

--AND realms_id LIKE 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE'

), tab2 as (

SELECT

PROPOSAL,

COUNT(DISTINCT tx_id) as votes,

count(DISTINCT VOTER) as voters,

sum(vote_weight) as voting_weight

FROM tab1

WHERE dao LIKE '{{dao}}'

GROUP BY 1

ORDER BY 4 DESC

LIMIT 10

SELECT

proposal,

VOTE_CHOICE,