sum(votes) tot_votes,

sum(voters) tot_voters,

tot_votes/tot_voters as vote_per_voter,

max(votes),

median(votes),

avg(votes)

FROM (

SELECT

date_trunc('hour', block_timestamp) as day,

count(DISTINCT voter) as voters,

count (distinct TX_ID) as votes

FROM osmosis.core.fact_governance_votes

LEFT outer join osmosis.core.dim_vote_options

on vote_id = vote_option

WHERE proposal_id = {{proposal_id}}

GROUP by 1