WITH A AS
    (SELECT MAX(AMT) AMT, CLASS_CODE
    FROM HOUSEHOLD
    WHERE
    PERSON_CODE <> '1'
    AND CLASS_CODE <> '01'
    GROUP BY CLASS_CODE)

SELECT
    CLASS_NAME CLASS
    ,PERSON_NAME PERSON
    ,H.AMT HOUSEHOLDS
FROM
    HOUSEHOLD H
    ,A
WHERE
    PERSON_CODE <> '1'
    AND H.CLASS_CODE <> '01'
    AND H.CLASS_CODE = A.CLASS_CODE
    AND H.AMT = A.AMT
ORDER BY H.CLASS_CODE