instructions[0]:accounts[0]::string AS voters ,

CASE

when instructions[0]:data = 'Yjf5DvKUCfa2bPkYz4AiWs' then 'Yes'

when instructions[0]:data = 'Yjf5DvKUCfa2Rh5YBEg7FM' then 'No'

end as vote,

SUM(ARRAY_SIZE(inner_instructions)) AS total_votes

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]:data IN ('Yjf5DvKUCfa2bPkYz4AiWs', 'Yjf5DvKUCfa2Rh5YBEg7FM')

GROUP BY 1, 2),

--tx_id = '5pTUfdXkHfG8WQhThmYW6fkVpp6oheTZRrLYD3mhANJ86XrkV75AQ8HNuj8CasHVrGHXGaep9nsNM4dTaVpYX4AB'

SMB_marketplace as (select

purchaser,

count(distinct mint) as NoOfSMB

from solana.fact_nft_sales

inner join voting_details ON voters = purchaser

where program_id = 'J7RagMKwSD5zJSbRQZU56ypHUtux8LRDkUpAPSKH4WPp' AND block_timestamp < '2022-02-15' AND succeeded = 'TRUE'

group by 1) ,

nft_metadata as (select

mint

from solana.dim_nft_metadata

where token_name = 'Solana Monkey Business' AND mint is not null),

MagicEden_marketplace as (select

pre_token_balances[0]:owner as seller,

post_token_balances[0]:owner as purchaser,

SUM(ARRAY_SIZE(post_token_balances)) AS total_purchase

from solana.fact_transactions f

inner join nft_metadata n ON n.mint = pre_token_balances[0]:mint::string