Query editor
WITH ns_create AS (SELECTblock_time,account_argumentsFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX' -- Name ServiceAND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0 -- NameRegistryCreate),domains AS (SELECTblock_time,element_at(account_arguments, 3) AS name_account, -- domain accountelement_at(account_arguments, 5) AS name_class, -- classelement_at(account_arguments, 6) AS parent_account -- parent (.sol TLD)FROM ns_create),sol_domains AS (SELECTDATE_TRUNC('month', d.block_time) AS month,d.name_accountFROM domains dWHERE d.name_class = '11111111111111111111111111111111'AND d.parent_account = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx' -- Direct parent is .sol TLDAND d.block_time >= DATE_TRUNC('month', DATE_ADD('month', -11, CURRENT_DATE)) -- last 12 months),months AS (SELECT CAST(x AS date) AS monthFROM UNNEST(SEQUENCE(DATE_TRUNC('month', DATE_ADD('month', -11, CURRENT_DATE)),DATE_TRUNC('month', CURRENT_DATE),INTERVAL '1' month)) AS t(x))SELECTm.month,COALESCE(COUNT(DISTINCT s.name_account), 0) AS sol_domain_registrationsFROM months mLEFT JOIN sol_domains s ON s.month = m.monthGROUP BY 1ORDER BY 1;