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