with tab1 as (select distinct proposer as "Proposer", count(distinct proposal_id) as "Proposals Count"

from ethereum.aave.ez_proposals

group by 1),

tab2 as (select voter, avg(voting_power)/pow(10,18) as "Average Voting Power (AAVE)", count(distinct tx_hash) as "Voting Count"

from ethereum.aave.ez_votes

group by 1)

select "Proposer", "Proposals Count", "Voting Count", "Average Voting Power (AAVE)"

from tab1 left join tab2 on tab1."Proposer"=tab2.voter

order by 2 desc