action,

count(distinct tx_hash) as txns_count

from near.core.dim_staking_actions

join near.core.fact_transactions

using(tx_hash)

where pool_address ilike '%paras.near'

and block_timestamp > current_date - interval '2 weeks'

group by 1