-- DISTINCT proposal

-- distinct realms_id

min(block_timestamp::date) as min_date,

count(distinct voter),

proposal,

case

when realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango'

when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape'

when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance'

when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend'

when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO'

when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex'

when realms_id = '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' then 'Jet'

when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum'

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

when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify'

else '0'

end as Protocol

from

solana.core.fact_proposal_votes

where

realms_id in ('DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip', 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn', 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6', '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh', '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg', '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' )

and succeeded = 'TRUE'

group by

proposal, Protocol

order by 1 desc