SELECT
    CLASS_NAME CLASS
    , PERSON_NAME PERSON
    , AMT HOUSEHOLDS
FROM
    HOUSEHOLD a
    INNER JOIN (
        SELECT
            CLASS_NAME CLASS
            , MAX(AMT) MAX_AMT
        FROM
            HOUSEHOLD
        WHERE
            PERSON_CODE <> '1'
            AND CLASS_CODE <> '01'
        GROUP BY
            CLASS_NAME
    ) b
        ON a.CLASS_NAME = b.CLASS
            AND a.AMT = b.MAX_AMT
ORDER BY
    CLASS_CODE
;