count(DISTINCT tx_hash) as n_proposals

FROM near.core.fact_transactions

WHERE tx_receiver = 'marketing.sputnik-dao.near' AND tx:actions[0]:FunctionCall:method_name = 'add_proposal'

GROUP BY tx_signer

ORDER BY n_proposals DESC