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