case when votes = '1' then '1 SMB' when (votes > '1' and votes < '4' ) then '2-3 SMBs' when votes > 3 then '4+ SMBs' end as situation

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]='EkugdcWDJD1zcmfYgPbC7PcqjMnQkNWMLSCJxmtLgztv'

and instructions[0]:data='YrpUV6EMK2i41e5L7STr9m'

group by wallet

order by votes desc