WITH RANKED_HOUSE AS (
    SELECT
        CLASS_CODE
        ,CLASS_NAME
        ,PERSON_NAME
        ,MAX(AMT) AS AMT
        ,RANK() OVER(PARTITION  BY CLASS_NAME ORDER BY AMT DESC) AS AMT_RANK
    FROM HOUSEHOLD
    WHERE CLASS_CODE != '01'
        AND PERSON_CODE != '1'
    GROUP BY CLASS_CODE, CLASS_NAME, PERSON_NAME
)
SELECT
    CLASS_NAME AS CLASS
    ,PERSON_NAME AS PERSON
    ,AMT AS HOUSEHOLDS
FROM RANKED_HOUSE
WHERE AMT_RANK = 1
ORDER BY CLASS_CODE;