SELECT DISTINCT PROPOSAL_AUTHOR,SPACE_ID

FROM ethereum.core.ez_snapshot )

SELECT PROPOSAL_AUTHOR, COUNT(*)

FROM t1

GROUP BY 1

ORDER BY 2 DESC

LIMIT 20