-- forked from snapshot_leaderusers_query7 @ https://flipsidecrypto.xyz/edit/queries/d74f27fd-7f92-479b-b886-e3f5790e81ea
SELECT
voter,
count(DISTINCT space_id) AS spaces,
count(DISTINCT proposal_id) AS proposals
FROM
ethereum.core.ez_snapshot
WHERE
proposal_start_time >= CURRENT_DATE - 30
GROUP BY
voter
ORDER BY
proposals DESC
LIMIT
10