with attempts as (

select

tx_hash

,block_timestamp

,tx_signer

,action_data

,action_data:args:message as message

,action_data:args:request_id as request_id

,action_data:method_name as method_name

from near.core.ez_actions

where block_timestamp > '2025-02-25'

and tx_receiver = 'neardevnewsletter-issue50.frol.near'

and action_name = 'FunctionCall' --the call made from the user

and tx_succeeded = 'TRUE'

and tx_signer <> 'neardevnewsletter-issue50.frol.near'--no avoid retrieving neardevnewsletter responses

--and tx_hash = '2zJwUHmexMVfJkJ2odwp4dvUQFEvagmFaR2TFLeeNMLg'

and block_timestamp < '2025-03-01 11:57:00' --seconds after the winner prompt was forwarded

select

count(distinct tx_signer) as users

,count(tx_hash) as attempts

from attempts