SELECT

depositor,

proposal_id

FROM osmosis.core.fact_governance_proposal_deposits

qualify(ROW_NUMBER() over(PARTITION BY depositor

ORDER BY

proposal_id ASC)) = 1

)

SELECT

count(DISTINCT depositor) as total_depositor,

proposal_id :: INTEGER as proposal_id

FROM proposal_depositors

GROUP BY proposal_id :: INTEGER

ORDER BY proposal_id :: INTEGER ASC