rezarwzWhat percentage of blocks have votes for these dao in them?
Updated 2022-08-16
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
›
⌄
with have_vote as(
SELECT
COUNT(DISTINCT BLOCK_ID) as number_of_block_have_votes
FROM solana.core.fact_proposal_votes
WHERE SUCCEEDED='TRUE' and GOVERNANCE_PLATFORM='realms' and
REALMS_ID in(
'DPiH3H3c7t47BMxqTxLsuPQpEC6Kne8GA9VXbxpnZxFE','By2sVGZXwfQq6rAiAM3rNPJ9iQfb5e2QhnF4YjJ4Bip','FiG6YoqWnVzUmxFNukcRVXZC51HvLr6mts8nxcm7ScR8',
'7sf3tcWm58vhtkJMwuw2P3T6UBX7UE5VKxPMnXJUZ1Hn','B1CxhV1khhj7n5mi5hebbivesqH9mvXr5Hfh2nD2UCh6','Cdui9Va8XnKVng3VGZXcfBFF6XSxbqSi2XruMc7iu817',
'2sEcHwzsNBwNoTM1yAXjtF1HTMQKUAXf8ivtdpSpo9Fv','78TbURwqF71Qk4w1Xp6Jd2gaoQb6EC7yKBh5xDJmq6qh','3MMDxjv1SzEFQDKryT7csAvaydYtrgMAc3L9xL9CVLCg',
'6orGiJYGXYk9GT2NFoTv2ZMYpA6asMieAqdek4YRH2Dn','7oB84bSuxv9AH1iRdMp5nFLwpQApv8Yo9s1gGmDkHtSP')
),
total as (
SELECT
COUNT(DISTINCT BLOCK_ID) as number_of_total_blocks
FROM solana.core.fact_blocks
)
SELECT
(number_of_block_have_votes/number_of_total_blocks)*100
FROM have_vote,total
Run a query to Download Data