Query editor
WITH domain_owners AS (SELECT owner_accountFROM dune.solananameservice.result_current_owners)SELECT COUNT(*) AS active_domainsFROM solana_utils.latest_balances lbINNER JOIN domain_owners doON lb.address = do.owner_accountWHERE lb.block_time >= NOW() - INTERVAL '180' DAY