WITH
proposers AS (
SELECT
proposer,
COUNT(DISTINCT proposal_id) AS proposals
FROM
ethereum.aave.ez_proposals
GROUP BY
proposer
)
SELECT
proposals AS "Proposals",
COUNT(DISTINCT proposer) AS "Proposers"
FROM
proposers
GROUP BY
"Proposals"
ORDER BY
"Proposers" DESC