Query editor
WITH ns_create AS (SELECTtx_id,block_time,data,account_argumentsFROM solana.instruction_callsWHERE executing_account = 'namesLPneVptA9Z5rqUDD9tMTWEJwofgaYwp8cawRkX'AND tx_success = TRUEAND BYTEARRAY_TO_BIGINT(BYTEARRAY_SUBSTRING(data, 1, 1)) = 0),registered_sol AS (SELECTtx_id,block_time,element_at(account_arguments, 3) AS name_account,element_at(account_arguments, 6) AS parent_accountFROM ns_create)SELECTCOUNT(DISTINCT CASEWHEN block_time >= DATE_ADD('hour', -24, CURRENT_TIMESTAMP)THEN name_accountEND) AS registrations_last_24_hours,COUNT(DISTINCT name_account) AS total_registered_sol_domainsFROM registered_solWHERE parent_account = '58PwtjSDuFHuUkYjH9BYnnQKHfwo9reZhC2zMJv9JPkx';