gv.voter,

vl.label,

count (distinct proposal_id) as voted_proposals,

--count (option) as votes_emitted,

(select count(distinct proposal_id) from terra.gov_vote) as total_proposals,

voted_proposals/total_proposals*100 as perc_voted

from terra.gov_vote gv

inner join terra.validator_labels vl

on gv.voter = vl.delegator_address

group by 1,2

order by 3 desc