barbodAverage / Luna
    Updated 2022-04-25
    with t1 as(SELECT
    MSG_VALUE:voter::string as voter
    from terra.msgs
    where MSG_TYPE='gov/MsgVote'
    and MSG_VALUE:option::string='VOTE_OPTION_YES')

    select
    count(PROPOSAL_ID) as vote,
    sum(voting_power) as voting_LUNA,
    voting_LUNA/vote as average_LUNA
    from terra.gov_vote
    where voter in (select voter from t1)

    Run a query to Download Data