'YES' AS ACTION,

'SLND1' AS AIP,

COUNT(TX_ID) AS "Total votes",

COUNT(DISTINCT VOTER) AS "Total voters",

SUM(VOTE_WEIGHT) AS "Total vote weight"

FROM solana.core.fact_proposal_votes

WHERE REALMS_ID = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn'

AND VOTE_CHOICE = 'YES'

AND PROPOSAL = 'HuaL6cDtuNtfnJgvwMnYiZDHVCoLAuDtVFgJD8kYChJ4'

UNION ALL

SELECT

'YES' AS ACTION,

'SLND2' AS AIP,

COUNT(TX_ID) AS "Total votes",

COUNT(DISTINCT VOTER) AS "Total voters",

SUM(VOTE_WEIGHT) AS "Total vote weight"

FROM solana.core.fact_proposal_votes

WHERE REALMS_ID = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn'

AND VOTE_CHOICE = 'YES'

AND PROPOSAL = '3geE5P3D7VJRaNNDVfZciGsXgwGiao1hSNpRM6jWNa5A'

UNION ALL

SELECT

'YES' AS ACTION,

'SLND3' AS AIP,

COUNT(TX_ID) AS "Total votes",

COUNT(DISTINCT VOTER) AS "Total voters",

SUM(VOTE_WEIGHT) AS "Total vote weight"

FROM solana.core.fact_proposal_votes

WHERE REALMS_ID = '7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn'

AND VOTE_CHOICE = 'YES'

AND PROPOSAL = 'CmrzCA2vQxqptyzZ8A9RSG9GeC7gB8nxKs2RvXiiwvh6'