select

tx_hash,

block_timestamp

from near.core.fact_actions_events

where action_name = 'DeployContract'

),

Tx_contract as (

select A.tx_receiver,

B.block_timestamp

from near.core.fact_transactions A

join Deploy_Contract B on A.tx_hash=B.tx_hash

and a.block_timestamp=b.block_timestamp

),

Smart_Contracts as (

select (tx_receiver),

block_timestamp,

row_number() over(partition by tx_receiver order by block_timestamp) as tx_receiver_Row

FROM Tx_contract

qualify (tx_receiver_Row=1)

)

select

count(distinct tx_receiver) as number_of_contracts

from Smart_Contracts