grahamProposal 2 vote outcome
Updated 2022-05-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with data_smb as (
SELECT
signers[0] as wallets,
case when instructions[0]:data = 'YrpUV6EMK2i4BLkLvFxTRH' then 'yes' else 'no' 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] = 'EkugdcWDJD1zcmfYgPbC7PcqjMnQkNWMLSCJxmtLgztv'
group by 1, 2 )
select
case when total_smb >=4 then '4+ SMBs'
else concat(total_smb, ' SMBs') end as labeling,
vote_choice,
count(wallets) as total_wallet
from data_smb
group by 1, 2
Run a query to Download Data