from solana.core.fact_proposal_votes--------Special table for Dao

where PROGRAM_NAME='GovHgfDPyQ1GwazJTDY2avSVY8GGcpmCapmmCsymRaGe'---general adrress contract

union select 'Mango' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-----------Special table for Dao

where PROGRAM_NAME='GqTPL6qRf5aUuqscLh8Rg2HTxPUXfhhAXDptTLhp1t2J'-------general adrress contract

union select 'Grape' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw'----general adrress contract

and REALMS_ID='By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip'

union select 'Solend' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='A7kmu2kUcnQwAVn8B4znQmGJeUrsJ1WEhYVMtmiBLkEr'----general adrress contract

union select 'The Imperium of Rain' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw'----general adrress contract

and REALMS_ID='6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn'

union select 'Metaplex Foundation ' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GmtpXy362L8cZfkRmTZMYunWVe8TyRjX5B7sodPZ63LJ'----general adrress contract

union select 'Metaplex Genesis' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GMpXgTSJt2nJ7zjD1RwbT2QyPhKqD2MjAZuEaLsfPYLF'----general adrress contract

union select 'Monke' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GMnke6kxYvqoAXgbFGnu84QzvNHoqqTnijWSXYYTFQbB'----general adrress contract

union select 'JET DAO' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='JPGov2SBA6f7XSJF5R4Si5jEJekGiyrwP2m7gSEqLUs'----general adrress contract

union select 'Serum' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='AVoAYTs36yB5izAaBkxRG67wL1AMwG3vo41hKtUSb8is'

union select 'Synthetify' as noun, count(distinct(TX_ID)) as votes

from solana.core.fact_proposal_votes-------Special table for Dao

where PROGRAM_NAME='GovER5Lthms3bLBqWub97yVrMmEogzX7xNjdXpPPCVZw'----general adrress contract

and REALMS_ID='7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP'