select distinct

case

when address_name ilike '%metaplex%' then 'metaplex'

when realms_id = 'By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip' then 'grape dao'

when realms_id = '6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn' then 'the imperium of rain dao'

when realms_id = '7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP' then 'synthetify dao'

else address_name

end address_name

,

count(distinct realms_id) space_count,

count(distinct proposal) proposal_count,

count(distinct voter) voter_count,

count(*) vote_count

from solana.core.fact_proposal_votes a

left join solana.core.dim_labels b on a.PROGRAM_NAME = b.address

where succeeded

and governance_platform = 'realms'

and (

address_name in ('mango dao','monkedao','jet dao','solend dao','psy finance','serum')

or address_name ilike '%metaplex%'

or realms_id in ('By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip','6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn','7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP')

group by 1

order by 5 desc