Updated 2024-05-28

    ENS as(
    SELECT OWNER,ENS_DOMAIN,COUNT(*) as hasEns
    FROM ethereum.ens.ez_ens_domains
    WHERE OWNER IN (SELECT SENDER_WALLET FROM L0)
    WHERE LENGTH(END_DOMAIN) > 2
    GROUP BY 1,2
    )

    SELECT a.*
    FROM ENS a
    JOIN ENS b ON a.ENS_DOMAIN LIKE '%' || b.ENS_DOMAIN || '%'
    WHERE a.row_num <> b.row_num;
    QueryRunArchived: QueryRun has been archived