SELECT TX_HASH AS hash

FROM near.core.fact_actions_events

WHERE action_name = 'DeployContract'

),

t2 AS (

SELECT MIN(BLOCK_TIMESTAMP) AS Deploy_date , TX_RECEIVER AS Contract1

from near.core.fact_transactions

Join t1 ON t1.hash = near.core.fact_transactions.tx_hash

WHERE TX like '%"method_name":"new"%'

GROUP BY 2

SELECT Count(*)

from t2