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