count (distinct TX_HASH) 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 ethereum.aave.ez_votes