latsanCopy of Untitled Query
Updated 2023-01-26
99
1
2
3
4
5
6
7
8
9
10
11
12
13
›
⌄
SELECT block_timestamp::date as time, -- date_trunc('day', block_timestamp) as time,
proposal_id,
CASE
WHEN proposal_id = 3619 THEN 'CommunityPoolSpend'
WHEN proposal_id = 3796 THEN 'SoftwareUpgrade'
else 'Nil'
END as proposal_type,
COUNT(DISTINCT voter) as voters,
COUNT(DISTINCT tx_id) as vote_count
FROM terra.core.fact_governance_votes
WHERE proposal_id in ('3619','3796')
GROUP by 1,2,3
order by 1 ASC
Run a query to Download Data