select count(distinct TX_RECEIVER)

from near.core.fact_actions_events s

join near.core.fact_transactions l

on s.tx_hash = l.tx_hash

where action_name = 'DeployContract'

AND l.block_timestamp::DATE > DATEADD(MONTH, -6, getdate()::DATE)