min(BLOCK_TIMESTAMP) as first_captured_vote,

count (distinct tx_id) as no_votes,

count (distinct voter) as no_voters,

count(distinct PROPOSAL_ID) as no_proposal,

no_votes/no_proposal as vote_per_proposal,

no_voters/no_proposal as voter_per_proposal

from lava.gov.fact_votes

where TX_SUCCEEDED = 'TRUE'