count(distinct receiver_id) as "Number of Distinct Deployed Contracts"

from

near.core.fact_receipts a join near.core.fact_actions_events b on a.tx_hash=b.tx_hash

where

action_name='DeployContract'