signers[0] as wallets,

case when instructions[0]:data = 'YyyskG9ERPr5mHk8rTkCKh' then 'airdrop' else 'entanglement' end as vote_choice,

SUM(ARRAY_SIZE(inner_instructions)) AS total_smb

FROM solana.fact_transactions

WHERE block_timestamp <= '2022-03-05'

AND block_timestamp >= '2022-02-15'

AND succeeded = 'True'

AND instructions[0]:programId = 'Daovoteq2Y28gJyme6TNUXT9TxXrePiouFuHezkiozci'

and instructions[0]:accounts[6] = 'GGKCaPonSGvyXas2uxUdBea2Gsa9X5RK91iN6Xu2V7v9'

group by 1, 2 order by 3 desc limit 10