min(t.BLOCK_TIMESTAMP) as time,TX_RECEIVER as smart_contract

FROM( near.core.fact_actions_events INNER JOIN near.core.fact_transactions t on t.TX_HASH = near.core.fact_actions_events.TX_HASH and t.BLOCK_TIMESTAMP=near.core.fact_actions_events.BLOCK_TIMESTAMP)

WHERE action_name = 'DeployContract'

GROUP BY TX_RECEIVER

ORDER BY time asc