WITH pre AS
(
SELECT
    CLASS_CODE
    ,CLASS_NAME AS CLASS
    ,PERSON_CODE
    ,PERSON_NAME AS PERSON
    ,AMT AS HOUSEHOLDS
FROM
    HOUSEHOLD
WHERE
    PERSON_CODE <> '1'
    AND
    CLASS_CODE <> '01'
)
,
pre_max AS
(
SELECT
    CLASS_CODE
    ,CLASS
    ,MAX(HOUSEHOLDS) AS HOUSEHOLDS
FROM
    pre
GROUP BY
    CLASS_CODE
    ,CLASS
)
SELECT
    pre.CLASS
    ,pre.PERSON
    ,pre.HOUSEHOLDS
FROM
    pre
    INNER JOIN
    pre_max
        ON
        pre.CLASS = pre_max.CLASS
        AND
        pre.CLASS_CODE = pre_max.CLASS_CODE
        AND
        pre.HOUSEHOLDS = pre_max.HOUSEHOLDS
ORDER BY
    pre.CLASS_CODE