MLDZMNCopy of Untitled Query
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT
count(DISTINCT ARGS:id) as no_proposals,
COUNT(DISTINCT a.TX_HASH) as no_vote,
count(DISTINCT ACTIONS:"predecessor_id") as no_voter,
COUNT(DISTINCT TX_RECEIVER) as no_validator,
COUNT(DISTINCT TX_SIGNER) as no_council,
no_vote/no_proposals as vote_per_proposal,
no_voter/no_proposals as voter_per_proposal,
no_vote/no_voter as vote_per_voter
FROM near.core.fact_actions_events_function_call a left join near.core.fact_transactions b on a.tx_hash = b.tx_hash
join near.core.fact_receipts c on a.tx_hash = c.tx_hash
WHERE RECEIVER_ID = 'marketing.sputnik-dao.near' and METHOD_NAME = 'act_proposal'
Run a query to Download Data