SELECT
    CLASS_NAME CLASS,
    PERSON_NAME PERSON,
    AMT HOUSEHOLDS
FROM (
    SELECT
        RANK() OVER (PARTITION BY CLASS_CODE ORDER BY AMT DESC) AS RANK,
        PERSON_CODE,
        CLASS_CODE,
        PERSON_NAME,
        CLASS_NAME,
        AMT
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE <> '1'
        AND
        CLASS_CODE <> '01'
) T
WHERE
    T.RANK = 1
ORDER BY
    CLASS_CODE ASC
;