ValiMohammadiUntitled Query
Updated 2022-12-13
99
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
›
⌄
-- with proposals as (
select
proposal_id,
'Prop #82' as props,
count(distinct tx_id) as votes,
count(distinct voter) as voters
from osmosis.core.fact_governance_votes
where proposal_id::integer = '82'
and tx_status = 'SUCCEEDED'
group by 1,2
UNION ALL
select
proposal_id,
'Recent Prop' as props,
count(distinct tx_id) as votes,
count(distinct voter) as voters
from osmosis.core.fact_governance_votes
where proposal_id::integer > '82'
and tx_status = 'SUCCEEDED'
group by 1,2
-- )
Run a query to Download Data