with tab1 as (

SELECT

tx_id

FROM solana.core.fact_events

WHERE INSTRUCTION:parsed:info:authorized:staker LIKE 'noMa7dN4cHQLV4ZonXrC29HTKFpxrpFbDLK5Gub8W8t'

and block_timestamp > '2023-7-18'

), tab2 as (

SELECT

DISTINCT INSTRUCTION['parsed']['info']['newAccount']

FROM solana.core.fact_events

WHERE tx_id in (SELECT * from tab1)

and block_timestamp > '2023-7-18'

AND event_type LIKE 'createAccount'

SELECT

count(DISTINCT signers[0]) as wallets

FROM solana.core.fact_events

WHERE event_type LIKE 'withdraw'

AND INSTRUCTION:parsed:info:stakeAccount in (SELECT * from tab2)

AND block_timestamp > '2023-7-18'