when realms_id = 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' then 'Mango DAO' when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'Grape DAO'

when realms_id = 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' then 'Psy Finance DAO' when realms_id = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' then 'Solend DAO'

when realms_id = 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' then 'MonkeDAO DAO' when realms_id = 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817' then 'Metaplex Genesis DAO'

when realms_id = '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' then 'Metaplex Foundation DAO' when realms_id = '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' then 'Serum DAO'

when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'The Imperium of Rain DAO' when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'Synthetify DAO'

end as realmsDAOs, proposal,min(block_timestamp) as Date_of_Creation

from solana.core.fact_proposal_votes where governance_platform = 'realms' and succeeded = true and realms_id in (

'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE', 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip','FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8', '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn',

'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6', 'Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817','2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv', '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg',

'6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn', '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP') group by realmsDAOs, proposal order by realmsDAOs,Date_of_Creation)

select max(Date_of_Creation) as Date_of_Last_Proposal,realmsDAOs from Dao group by realmsDAOs