with marketing_dao_proposals as (
select
*
from
near.core.fact_receipts
where receiver_id = 'marketing.sputnik-dao.near'
and actions:receipt:Action:actions[0]:FunctionCall:method_name = 'add_proposal'
)
select
count(distinct tx_hash) as "Number of Proposal"
from marketing_dao_proposals