t1 as (

select

distinct TX_RECEIVER as smart_cnt,

min(block_timestamp) as date1

from near.core.fact_transactions

where tx_status = 'Success'

group by 1

)

select

count(smart_cnt) as "Number of New Smart Contracts"

from t1

where date1 >= CURRENT_DATE - INTERVAL '14 days'