SELECT
      a2.CLASS
    , a2.PERSON
    , a2.HOUSEHOLDS 
FROM
    ( 
        SELECT
              a.CLASS_NAME "CLASS"
            , a.PERSON_NAME "PERSON"
            , a.AMT "HOUSEHOLDS"
            , a.CLASS_CODE
            , ROW_NUMBER() OVER (PARTITION BY a.CLASS_CODE ORDER BY a.AMT DESC) "NO_CLASS" 
        FROM
            HOUSEHOLD a 
            INNER JOIN HOUSEHOLD b 
                ON a.PERSON_CODE = b.PERSON_CODE 
                AND a.CLASS_CODE = b.CLASS_CODE 
                AND b.PERSON_CODE <> '1' 
                AND b.CLASS_CODE <> '01'
    ) a2 
WHERE
    a2.NO_CLASS = 1 
ORDER BY
    a2.CLASS_CODE;