tx_from,

case when tx_to like 'YESsimd228111111111111111111111111111111111' then 'Yes'

when tx_to like 'nosimd2281111111111111111111111111111111111' then 'No'

when tx_to like 'ABSTA1Nsimd22811111111111111111111111111111' then 'Abstain' end as vote_choice,

sum(AMOUNT) as votes_cast

from solana.core.fact_transfers

where mint like 's228VmFcuiEfroSCQTvEp1pYUownL7JRZMTd7FqHJVK'

and tx_to in (

'YESsimd228111111111111111111111111111111111'

group by 1,2

order by 3 desc