with tbl1 as (

SELECT min(block_timestamp) as date,

address_name,

realms_id,

proposal

FROM solana.core.fact_proposal_votes join solana.core.dim_labels on address=program_name

WHERE governance_platform='realms'

AND succeeded='TRUE'

AND realms_id in ( 'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE' --Mango DAO

, 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' --grape DAO

, 'FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8' --Psy finance

, '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn' --Solend DAO

, 'B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6' --Monke DAO

, '2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv' --Metaplex foundation

, '78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh' --Jet DAO

, '3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg' --Serum DAO

, '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' --The imperium of rain

, '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' --Synthetify

)

group by address_name, realms_id, proposal

order by date desc

)

SELECT max(date), address_name, realms_id

from tbl1

group by address_name, realms_id