WITH ranked AS (
    SELECT
        PERSON_CODE,
        CLASS_CODE,
        PERSON_NAME,
        CLASS_NAME,
        AMT,
        ROW_NUMBER() over(partition by CLASS_CODE ORDER BY AMT DESC) AS SCORE
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE != '1'
    AND
        CLASS_CODE != '01'
)
SELECT
    CLASS_NAME AS CLASS,
    PERSON_NAME AS PERSON,
    AMT AS HOUSEHOLDS
FROM ranked
WHERE SCORE = 1
ORDER BY CLASS_CODE ASC
;