SELECT DISTINCT node_id

FROM flow.gov.ez_staking_actions

WHERE action = 'NewNodeCreated'

AND tx_succeeded = TRUE

),

existing_actions AS (

SELECT DISTINCT node_id

FROM flow.gov.ez_staking_actions

WHERE action IN ('TokensStaked', 'DelegatorTokensCommitted')

AND tx_succeeded = TRUE

SELECT

COUNT(nn.node_id) AS total_new_nodes

FROM

new_nodes nn

LEFT JOIN

existing_actions ea ON nn.node_id = ea.node_id

WHERE

ea.node_id IS NULL;