with code1 as (
SELECT TX_RECEIVER, TXN_HASH
FROM flipside_prod_db.mdao_near.transactions
where BLOCK_TIMESTAMP>=CURRENT_DATE-180
),
code2 as (
select TXN_HASH
from flipside_prod_db.mdao_near.actions_events
where ACTION_NAME='DeployContract'
)
SELECT COUNT (distinct TX_RECEIVER) as "new smart contracts"
from code1 a join code2 b on a.TXN_HASH=b.TXN_HASH