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