WITH HH AS(
    SELECT
        CLASS_CODE,
        CLASS_NAME AS CLASS,
        PERSON_NAME AS PERSON,
        AMT AS HOUSEHOLDS
    FROM
        HOUSEHOLD
    WHERE
        PERSON_CODE <> '1'
        AND CLASS_CODE <> '01'
)
SELECT
    CLASS,
    PERSON,
    MAX(HOUSEHOLDS)
FROM
    HH
GROUP BY
    CLASS
ORDER BY
    CLASS_CODE ASC
;